Link to home
Start Free TrialLog in
Avatar of ammartahir1978
ammartahir1978Flag for United Kingdom of Great Britain and Northern Ireland

asked on

how to a refresh buttin in excel to run a query

hi guys,

how can i put a refresh butting in excel which when press runs a sql query to import data from SQl tables?

i have the query, and i have tried to do it but when i do new database query from tool it doesnt show me the tables i need.

help

thank you
Avatar of Steven Harris
Steven Harris
Flag of United States of America image

Are you saying that you are able to conenct to the server but not import the SQL tables you need, or that you have all of that configures and just need to refresh the connection with a button?
Avatar of ammartahir1978

ASKER

no when i connect to server i can not see the tables...but can you please let m eknow if i have a SQL query which works fine when i run on SQL server and give me correct results.

can you show or give a macro which i can insert in excel spread sheet and run it and put a refresh button to extract the info everytime?

Thank you for your help
ASKER CERTIFIED SOLUTION
Avatar of Steven Harris
Steven Harris
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
good