Useful Visual Foxpro Codes - Data Convertion

1. Copy Foxpro Table to Excel File
sele table1
copy to excelname type xls
-> the code will create excelname.xls file wich contains the data of table1

2. Copy Foxpro Table to Textfile (comma delimited)-CSV
sele table1
copy to text.txt delimited
-> the code will create text.txt file wich contains the data of table1

3. Copy Foxpro Table to Textfile (delimited with any character)
sele table1
copy to text.txt delimited with character "|"
-> the code will create text.txt file wich contains the data of table1

4. Append data t0 Foxpro Table from Excel File
sele table1
append from excelname.xls type xls
-> the code will append excelname.xls data to table1
-> note excel file must be plain data - no attachments (pictures,drawings,etc..)

5. Append data t0 Foxpro Table from Textfile (comma delimited)-CSV
sele table1
append from text.txt delimited
-> the code will append text.txt file data to table1

6. Append data t0 Foxpro Table from Textfile (delimited with any character)
sele table1
append from text.txt delimited with caracter "|"
-> the code will append text.txt file data to table1