Export to excel

[Guest]

When I format the columns in a query and the export the results to excel I
lose the formatting. How do prevent this?

 

[Bongard]

When I format the columns in a query and the export the results to excel I
lose the formatting. How do prevent this?

There is no way to prevent this. The formatting in an Access query is
not transalated into the Excel file. If you want, just record a macro
to format the Excel file and then everytime you do the export just
click the button to reformat it how you'd like. Otherwise name the
macro auto_open and it will run and format the data quickly everytime
you open the file.

Goodluck

 

[Gina Whipp]

Try:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=ExportToExcel.mdb
from Roger Carlson. It might give you waht you need.