steps to create a macro to refresh data of a sql query

[sameer11]

Hi All,

I have never done this before nor have any clue about how I can do this

I have to create a macro to refresh the data of the Sql query I have.

I will have to create a button which says "Refresh" and then when a user click the button the data should get refreshed for a sql query.

Say for ex: Select * from schema.table1



I have figured to create a button and rename it to as "Refresh" but how do I make the sql run.

Any help is apperciated.

Thanks in Advance,
sameer

 

[PHV]

Create a QueryTable: menu Data -> External data -> ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sameer11]

I really apperciate your help..

I am a dummy what do i do next after the external data
I choose the data source(odbc) and selected the table and field and filter I needed. The excel print the columns for the query. What do I do next to create a macro?

 

[SkipVought]

If you ALREADY have a QueryTable on your sheet...

Select in the QueryTable Data

Data/Refresh.

You can macro record doing that and post back with your code.

How many QueryTables do you need to refresh?

Skip,
[sub]
[red][/red]
[/sub]