How to pass records from MS Access to an MS Excel template
Posted on 2014-12-10
I am familiar with how to establish a MS Excel session within MS Access and manipulate records within MS Excel from MS Access However, if I need to take a 1000 records from an MS Acccess table (75 columns) and put that information into an MS Excel template file what is the most efficient way of accomplishing this task. Any links or example would be great.
I assume I would want to loop thru my table and work on a record at a time keeping track of what row I am on within MS Excel...
Note I can not do a docmd since the purpose of the MS Excel template is to avoid any formatting I may need to do once the data is within MS Excel. However, I am wondering if I am better off doing a docmd and getting the data out into the workbook and then attempting the formatting from within MS Access