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.
 

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

Export Delimited 1
Export to Tab delimited text file 4
Exporting .TAB file 1
TransferSpreadsheet still truncates the memo field 1
Export wizard slow when using special delimiter 1
transfertext, format () does NOT work with pipes!?! 2
how to change default values (delimiter etc) for Export Wizard 6
Exporting Table to Text file including Fielnames 2

Back
Top