Set up the querytable as you outlined. Once you have it on the worksheet, switch to the VBEditor, then in the immediate window (Ctrl+G to open that if it's not visible) and type:
?Activesheet.Querytables(1
and press enter. This should output the connection string more or less as you need to use it with ADO.
Regards,
Rory
Main Topics
Browse All Topics





by: jocasio123Posted on 2007-12-21 at 12:07:36ID: 20516032
I'm not sure how to do that as a macro, but I think Once you have everything in A1, you can Select Data->Text to Columns and separate the columns that way.