Saving an Export Text Wizard for an MSAccess Table or Query?

[Guest]

I need to export an MSAccess query to a delimited text file. The Export Text
Wizard appears to read through all records in the query as it completes each
step, such as selecting the Delimiter or setting the Text Qualifier. Is it
possible to save the Wizard and specify the Export Format for future Exports
of the same Query?

 

[Roger Carlson]

Yes. On the Advanced tab of the wizard, you can use the SaveAs button to
save the specification. Then use this specification in your export.

--
--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