Export database as tab delimited in a script

Exporting expressions and information including exporting data in presort order or import order, and importing information, along with error messages that may apply to this category.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1910
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Export database as tab delimited in a script

Post by Eric » Tue Jan 08, 2013 10:22 am

Here is a command that will export the active database as a text tab delimited file, in the current directory, with the same name as the active database in a script.

Code: Select all

Set Safety OFF
copy to "C:\temp_.csv" type csv
zap 
append from "C:\temp_.csv" type delimited
COPY TO FORCEEXT(dbf(),"txt") TYPE DELIMITED WITH TAB
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply