Export to the same path as the currently open database

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 to the same path as the currently open database

Post by Eric » Fri Feb 01, 2013 9:40 am

******************************************************************************************
*
* Run the command from the Edit>Commands window.
* The command will create an ".XLS" file in the same directory as the database you're * running it on.
*
COPY TO forceext(dbf(),"XLS") type xls
*
******************************************************************************************
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

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

How to export an .xml file with a command

Post by Eric » Thu Dec 12, 2013 8:05 am

How to export an .xml file with a command

Code: Select all

SET SAFETY OFF
CALIAS="C:\"+FORCEEXT(FORCEEXT(JUSTFNAME(DBF()),"")+"_OP","XML")
CURSORTOXML(ALIAS(),CALIAS,1,512,0,"")
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply