Adding Data to Excel Spreadsheet from Access Programmatically

[soonerman1978]

Thanks for taking the time to look at this.

I have got my Excel Spreadsheet to open and put out column headings. But I appear to have hit a bump. I have no clue (even after hours of research ) how to get the data from my Access database to this Excel spreadsheet. Any help on this is much appreciated..... Thanks

 

[WMcGregor]

What are you trying to accomplish? You can send data from Access to Excel using the Docmd.OutputTo command:

DoCmd.OutputTo acOutputQuery, "qryMy_Data", acFormatXLS, "MyData.xls", True

If you want more flexibility, I can send you some code that spins through a recordset and builds an excel spreadsheet manually...

Bill