XLS Converter
News Download Features Order Screenshots Contacts FAQ

Convert XLS to SQL

Sometimes users need to convert a Microsoft Excel table 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

XLS to SQL conversion via command line

xlscnv.exe file.xls file.sql [/ORACLE | /MYSQL | /MSSQL | /FILTER | /COLUMNS | /COLUMNSLIST | /REVERSE]

Convert XLS to Oracle script

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

Convert only two columns from XLSX to MySQL

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

Convert folder with XLS files to MS SQL

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

Convert XLS tables to MySQL

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


Updated Mon, 13 Mar 2017

Back to XLS Converter Home


See also:
Convert XLSX to XLS
Convert XLS to XML
Convert XLS to DBF
Convert XLS to CSV

Copyright © XLS-CONVERTER.COM, 2002-2017