Convert XLS to SQL Script

Sometimes users need to convert a Microsoft Excel database to SQL but do not have a dedicated tool to do the conversion, or the price of this tool is too high. Advanced XLS Converter is a remarkably accurate XLS converter that produces SQL outputs instantly and without any learning curve. Advanced XLS Converter supports batch conversion, handles extremely large databases and allows you to customize output settings to your requirements.

Advanced XLS Converter allows you convert a single excel file or folder with excel files to sql format from GUI or command line.

1. Select the xls (excel) file or select folder with xls files for batch conversion.
2. Select the output sql file.

xls to sql conversion

3. Preview, select options for sorting, filtering data (if necessary)
You can also select/unselect columns, set order for columns.

XLS Converter Common options

4. Select options for sql format: SQL Syntax (MS SQL, Oracle, MySQL, PostgreSQL), rows delimiter (if necessary), and click "Finish"

SQL file format options in XLS Converter

Convert XLS to SQL from the command line

Example 1 (convert xls to Oracle script)

"c:\Program Files\Advanced XLS Converter\xlscnv.exe" sample.xls sample.sql /ORACLE

Example 2 (convert only two columns from xls to MySQL)

"c:\Program Files\Advanced XLS Converter\xlscnv.exe" sample.dbf sample.xls /COLUMNS:NAME,STREET /MYSQL

Example 3 (convert folder with xls files to MS SQL)

"c:\Program Files\Advanced XLS Converter\xlscnv.exe" d:\base\ d:\out\ /TOSQL /SQL2000

Download Advanced XLS Converter Free Trial Version