Maintaining Field (Column) Order on Import and Export in Access 20

M

Mike Bailey

I frequently import text files into Access 2007, then export again with some
format changes. The input and outputs are both tab delimited. I have created
and saved import and export specifications to create the results I need.

The issue is that Access 2007 rearranges the columns. I don't have the
problem with Access 2003 when I use the same specification.

How can I maintain the column order through the import and export processes?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Access Table to text file 9
Error Saving Import/Export Spec 1
Import/Export Specification Error 1
Import Specifications Broken? 1
Export from 2007 using Export Specification. 2
Import Specs Changed "Magically" in Midst of Loading Sequence 3
Export/Import .dat file extension 2
Importing Fixed Length File into Access 2007 1

Top