Export from 2007 using Export Specification.

[trist123]

When I export to a text file using the Export specification -

I want to change the order of the column export so I swap the field names in
the export specification - this used to work for all other versions of
access. However 2007 seems to ignore my export order. and just exports using
the table order.

Anyone else had a similar issue ?

 

[Roger Carlson]

Can you export it from a query that has the fields in the order you want
instead of directly from the table?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[trist123]

Thats exactly how I got around it. But if I need to export a single table
multiple times in differing orders I will now need queries and export specs
for each export - however before I only needed export specs ? Was wondering
if anyone else had the same issue ?