Excel Sheet in Access

[Adam McReynolds]

I am looking to either embed an Excel sheet into a report/form or have the data in Access export to a pre-formatted Excel sheet. I know how to export to Excel but not how to get it to export to specific cells in Excel. My Excel template(attached) has space for 15 records and the Access data will have a variable amount of records so I need it to fill the 15 rows in Excel and fill out another sheet to meet the amount of records. Any help or suggestions would be greatly appreciated.

 

[namliam]

You can open any excel sheet by opening excel in code and write a controlled number of records and do any magic you envision.

Research Excel.Application a bit and see what you can find/do come back with any questions.