Exporting large-sized files from FoxPro to MS Excel or Open Office Spreadsheet

Asked By Sabelle Vian 10 points N/A Posted on - 04/15/2012

How can I export large-sized files from FoxPro version 6.0 to Microsoft Excel or Open Office Spreadsheet?

• Status: Open
• Question Views: 1851
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: FoxPro

Answered By Mark Amna 5 points N/A #114733

Exporting large-sized files from FoxPro to MS Excel or Open Office Spreadsheet

Hello Sabelle,

 

You can transfer a FoxPro or Visual FoxPro file to Excel Spreadsheet by using “Copy to” control or the export wizard to turn each table into an Excel spreadsheet but with limitations. Microsoft Excel can open few older format .DBFs. Therefore, depending on how old your data was, you can be able to

Excel can open some older format DBFs, so depending how old your data is, you may be able to do it by just opening it from MS Excel and indicate "dBase files."  FoxPro tables can also be exported or transferred in CSV format on which a Excel Spreadsheet can be able to read. Nevertheless, please ensure that you have working FoxPro for that thing.

Tip:

You can use to open the data and export or transfer it if you have VFP ODBC driver.

 

 

I hope this helps

About Mark Amna

Questions
0

Answers
90

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 04/26/2012
• Question Category: FoxPro