Export to excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mlogistics - 05 Sep 2007 14:36 GMT

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

Signature

Thanks
Mlogistics

Reply to this Message

Bongard - 05 Sep 2007 17:58 GMT

On Sep 5, 8:36 am, mlogistics <mlogist...@discussions.microsoft.com>
wrote:

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

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

Reply to this Message

Gina Whipp - 05 Sep 2007 18:44 GMT

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

Signature

Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

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

Reply to this Message