FoxPro to CSV

[Download] Latest version 1.0 released 05/16/2016

FoxPro-to-CSV is a free program to convert FoxPro/DBase databases into comma separated values (CSV) files. The program has high performance due to direct connection to source databases and writing into .csv files (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

  • All formats of FoxPro data and MEMO files are supported
  • Support for large .dbf files (4GB+)
  • High performance due to direct connection to source and destination databases (the program does not use ODBC or any other middleware software)
  • Option to select separator: tab, comma or semicolon
  • Option to store conversion settings into profile
  • Command line support
  • Easy-to-use wizard-style interface
  • Full install/uninstall support
  • Unlimited 24/7 support service
  • Freeware!

Requirements

  • Supported OS: Windows XP(SP2 or SP3)/Vista/7/8/10, Server 2003/2008/2012/2016, Linux with WINE

    
1. Welcome Screen 2. Connect to Microsoft SQL Server
3. Conversion Settings 4. Select Tables

Download FoxPro-to-CSV converter

Command Line

To perform batch conversion or call the conversion procedure from an automation script you can use console version of FoxPro-to-CSV D2CAGENT.EXE. Find this file in FoxPro-to-CSV installation folder. You can either run this tool directly from command line or call it from any script as well. The program supports the following command-line options:

--dest=...   path to the folder with .csv files
--help   display help message and exit
--inc_fnames   include FoxPro field names into CSV files
--logfile=...   path to the log file where execution traces will be written
--mode=...   how to process an existing CSV folder (0 - overwrite the entire folder, 1 - overwrite existing files only, 2 - skip existing files)
--n_delim=...   delimiter symbol to use in the resulting CSV file (0 - tab, 1 - semicolon, 2 - comma)
--profile=...   path to the file to load conversion settings from
--silent   use this option to disable program output
--src=...   path to FoxPro database files (.dbf)
--tab_file=...   file containing the list of tables to convert
(one table name per line)

In the following example the program converts FoxPro database stored in the folder "c:\db 1" into .csv files in folder "c:\from dbf" using table names file "c:\tabfile1.txt":

M2CAGENT.EXE --src="c:\db 1" --dest="c:\from dbf" --tab_file=c:\tabfile1.txt 

Table names file should be formatted as follows:

Table_1
Table_2
...
Table_N

Notes:

  1. If you omit 'tab_file' parameter, all database tables will be converted
  2. Command line parameters that contain spaces should be enclosed in quotes (for example --dest="c:\my database")
  3. If you omit 'mode' parameter, default mode 'overwrite the entire folder' will be used

Download FoxPro-to-CSV converter