EXPORTING AS ~ Delimited

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

what is the easiest way to export the results of a query to a ~ delimited
flat file?



Thanks in advance.
 
Should clarify a little...

I need to have the export performed by Using VBA code or module

thanks.
 
Export the query once manually. As you do so, click the Advanced button
in the text export wizard, and create and save an import/export
specification that uses ~ as the delimiter.

Subsequently, pass the name of this specification when you call
DoCmd.TransferText.
 
Back
Top