Export DBF to SQL

To export a dbf file to sql script, open File | Save as/Export menu, and select file type: SQL.

Export to dialog box opens. Select the fields to be exported and specify their order using up and down arrows.

dbf-to-sql

Select the SQL format from the list (Oracle, MySQL, MS SQL, PostgreSQL)

Export DBF to SQL from the command line:

"c:\Program Files\DBF Viewer 2000\dbview.exe" dbffile /EXPORT:sqlfile [/mysql | /oracle | /mssql | /postgresql] [/NOCREATESTATEMENT] [/insertwithcolumns] [/COLUMNS] [/FILTER] [/WFILTER]

examples:

Export DBF to MySQL

"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.sql /mysql /COLUMNS:ZIP,NAME,ADDR

Export DBF to MS SQL

"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.sql /mssql

Export DBF to Oracle with wide filter option

"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.sql /oracle /wfilter:alaska

Export DBF to PostgreSQL

"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.sql /postgresql

Download DBF Viewer and Editor