Hi,
I was wondering what is the best way to retrieve data from Access to an Excel sheet.
I have an excel template that I extract the tables from Access and have the VBA code just filling in the cells by doing vlookups from this Access extract.
I was wondering how could code the Excel template to retrieve the data straight from the database tables.
For instances, cell A1 needs to be populate with the costs of widget1, so Lolokup Access tblWidgets and pulls back the cost related to widget1. Then cell A2 needs to be populate with the description of widget1, so Lolokup Access tblWidgets and pulls back the description related to widget1. etc
Thanks!
Bookmarks