EXPORTING AS ~ Delimited

G

Guest

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



Thanks in advance.
 
G

Guest

Should clarify a little...

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

thanks.
 
J

John Nurick

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
Export wizard slow when using special delimiter 1
TransferSpreadsheet still truncates the memo field 1
how to change default values (delimiter etc) for Export Wizard 6
Fixed Width - No delimiters - ASCII Text File 7
transfertext, format () does NOT work with pipes!?! 2

Top