Exporting table to Excel, columns moved

[Meplustwo]

Has anyone else had the same problem? Every time I export tables from Access
into a new excel spreadsheet it moves the columns around. I have gone through
and put my columns in order in Access and saved the format. Then I try to
export them into Excel and the columns are all moved around. Does any body
have any ideas how to stop this?
-- Very Frustrated!

 

[Ken Snell [MVP]]

Try creating a new query that returns all the records and fields from the
table. Make sure the field order in the query is what you want. Export the
query.

 

[Meplustwo]

Thanks SO much Ken. Your tip worked! I have never had to do this step before.
But since we have upgraded from Microsoft Office 2003 to 2007 I have been
experiencing this problem. And when time is of the essence it is very
frustrating to have to rearrange the columns when they get into Excel.