I'm trying to export data from SQL server into an excel table using VBA. At the moment the tables are connected to the server and I have a macro that pulls the data in;
I want to be able to run the two tables seperately, so I insert the first table, insert 2 rows, then insert the second table.Please Login or Register to view this content.
Are there any ideas on how to do that??
Thanks
Bookmarks