Import data from online Excel file to SQL Server without programming

by

Want to parse online Excel file and save to SQL Server ? Want to schedule and automate this converting task?

Using XlsToSql, you can convert online EXCEL file to SQL Server table easily and fast, and schedule and automate this converting task easily, no need to program, just a few mouse clicks!

Please download and install XlsToSql.

Convert online EXCEL file to SQL Server table

Click “Wizard – 1 File To 1 Table” at task dialog.

convert online EXCEL file to SQL Server table - task window

Select “Source File From” with “Url”.

convert online EXCEL file to SQL Server table - select type

then show the wizard.

1. Input the EXCEL file URL, and download the file.

convert online EXCEL file to SQL Server table - download from EXCEL file URL

2. Open the saved EXCEL file.

convert online EXCEL file to SQL Server table - open saved EXCEL file

3. Config target SQL Server table.

convert online EXCEL file to SQL Server table - config SQL Server table

4. Summary.

convert online EXCEL file to SQL Server table - summary

5. Convert.

convert online EXCEL file to SQL Server table - convert to SQL Server table

See SQL Server table

convert online EXCEL file to SQL Server table - view  SQL Server table

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.


More about XlsToSql – the tool to convert online EXCEL file to SQL Server table

30-day free trial Download XlsToSqlUS$59.95 Buy XlsToSql