Returning data to excel from msquery

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

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
 
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
=====================================================
 
Back
Top