Export to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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
 
Back
Top