Export Access table to a pre-formatted Excel file
I'd like to export data from my Access database into a pre-formatted Excel spreadsheet. Row 2 of the Excel spreadsheet has corresponds to fields in my database table starting at column 2 with borders, cell shading, bold text, etc. There's only one worksheet in my Excel template file. I use the Excel table for insertion into monthly flyers and such. I have an existing design I'd like to use. Can anyone tell me if it's possible to export data from my Access table to the Excel worksheet so the data is placed in the appropriate cells and/or rows and retain my formatting and perhaps how to go about making it so? Or, could Access be made to more or less replicate the Excel template during the export (borders, column/row labels, cell shading)?
|
