Exporting from Access to Excel keeping EXCEL formatting

[mike]

I have coded the process of 1. creating an Excel file via MS Access,
2. adding several tabs in the workbook each with different datasets on
each tab and 3. I manually update the formatting of the columns,
borders, etc. each time.

I run this routine weekly and I am growing tired of reformatting the
first row (column headings), column widths, etc. every time I run the
routine. Is there a way to export the data to a range in the
worksheet similar to importing a range? For example, I want to export
all of the data in Query 1 to Sheet 1 beginning with cell A2. Then, I
want to export Query 2's data to Sheet 2 beginning with cell A2, and
so on.

Hopefully, this makes sense. I can create a macro in Excel and
execute the macro each time but I wanted to see if there was another
way to skin this cat...managing the macro from workbook to workbook
could be a bear after a while.

Thanks.

 

[Douglas J. Steele]

See my July, 2005 "Access Answers" column in Pinnacle Publication's "Smart
Access".

You can download the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html

 

[mike]

Thank you VERY much for the assistance. Fortunately, this is what I
was looking for. UNFORTUNATELY, you've opened my eyes to whole
boatload of more potential I had not thought about...lol. Thanks for
the extra work ;-) Take care.