EXPORTING AS ~ Delimited

F

ftrujill0

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



Thanks in advance.
 
F

ftrujill0

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

Sorting and filtering text 0
Solved Disk Full error message when exporting PDF 0
Export Delimited 3
Exporting .TAB file 1
TransferSpreadsheet still truncates the memo field 1
Delimited Export Specification - independent of table 3
Access 2016 docmd sendobject crash after March update 0
Export to Tab delimited text file 4

Top