Exporting MS Access Data to MS Excel Template

Jeffrey Sanchez
Jeffrey Sanchez used Ask the Experts™
on
Hi, I am creating an Access database and want to export my data to MS Excel Templates.  I can export the data to excel and in the code format the spreadsheet however, I have 30+ templates I want to utilize and formatting all of them through code would be extremely time consuming.  Is there a way I can utilize my existing templates and export the data to them.  Or is there a way I can capture the formatting of each MS Excel file and copy it into the code?  Thank you, Jeff
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer

Commented:
How exactly you export to Excel ? if you use the builtin commands (e.g. TransferSpreadsheet ) then you have very little controller over the resulting Excel....in this case you need Excel automation (take a look here for start) in order to have Excel as object in your Access and manipulate it accordingly...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial