Thread
:
Returning data to excel from msquery
View Single Post
#
2
Posted to microsoft.public.excel.programming
BrianB
external usenet poster
Posts: 109
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 With Quote
BrianB
View Public Profile
Find all posts by BrianB