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, SQL 2000, PostgreSQL)

Export DBF to SQL from the command line:

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

examples:

DBF to MySQL

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

DBF to SQL2000

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

DBF to Oracle

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

DBF to PostgreSQL

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