p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access VBA (http://p2p.wrox.com/forumdisplay.php?f=80)
-   -   Export Access table to a pre-formatted Excel file (http://p2p.wrox.com/showthread.php?t=58336)

mccoy May 24th, 2007 06:41 PM

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)?

mmcdonal May 25th, 2007 06:37 AM

Yes. O'Reilly Publishing: "Integrating Excel and Access."

Paperback: 232 pages
Publisher: O'Reilly Media, Inc. (November 1, 2005)
Language: English
ISBN-10: 0596009739

This is THE book for this subject matter. Too much info to post here.

Sorry Wrox.


mmcdonal

mccoy May 25th, 2007 08:04 AM

Sweet! Thanks for the recommendation.


All times are GMT -4. The time now is 05:37 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.