Exporting table to Excel, columns moved

  • Thread starter Thread starter Meplustwo
  • Start date Start date
M

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