Hi Guys,
The code below does what I need- It runs a simple parameter query in Access by using the parameter value from Excel cell , it then pastes the output back to Excel file. I just started working with Access and don't get why it only works with a Select query. What do I do to make it work with a query that is saved as "Make Table" Query that creates a table called "Table1"?
Thanks a lot!
Please Login or Register to view this content.
Bookmarks