Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning data to excel from msquery
Hi
Hi I'm importing data from a database via msquery. Instead af using time to establish connection severel times and each time returning data to excel, placing data different places - is there a way to open the connection (one time) making severel sql's - placing result different places in sheets - and afterwards closing the connection? Kind Regards Kim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning data to excel from msquery
Save your query and then set the macro recorder while you run it. This
will give you the basis of a more customised macro. Regards BrianB ================================================== === (Kim) wrote in message . com... Hi Hi I'm importing data from a database via msquery. Instead af using time to establish connection severel times and each time returning data to excel, placing data different places - is there a way to open the connection (one time) making severel sql's - placing result different places in sheets - and afterwards closing the connection? Kind Regards Kim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting external data from Access 2007 using msquery | Excel Discussion (Misc queries) | |||
Creating a profit and loss from MSQuery Data | Excel Discussion (Misc queries) | |||
MSQuery does not see the tables in an excel workbook, help. | Excel Discussion (Misc queries) | |||
msquery in Excel 2007 | Excel Discussion (Misc queries) | |||
MSQuery editing source data? | Excel Discussion (Misc queries) |