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.

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

DBF to SQL exporting via Command Line

"c:\Program Files\DBF Viewer 2000 (x86)\dbview.exe" dbffile /EXPORT:sqlfile [/MYSQL | /ORACLE | /MSSQL | /POSTGRESQL ] [/NOCREATESTATEMENT] [/CREATEONLY] [/INSERTWITHCOLUMNS] [/COLUMNS] [/FILTER] [/WFILTER]

examples:

Export DBF to MySQL

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

Export MS SQL

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

Export DBF to Oracle with wide filter option

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

Export DBF to PostgreSQL

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

Inserting Columns Names

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:myscript.sql /mysql /INSERTWITHCOLUMNS

Export to MySQL with Wide filter

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.sql /mysql /wfilter:smith

Export without INSERT commands

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.sql /mysql /CREATEONLY

DOWNLOAD
for FREE

Updated Tue, 10 Jun 2025