Download Load Excel Files Into SQL Server. No schema changes requiered!
Description
Load Excel files into SQL Database for further processing, analysis and validation. Without schema changes!
Source Files
The download file excel2sql.zip has the following entries.
ExcelToSql/App.config/*w ww.j a v a2 s .c om*/
ExcelToSql/App.xaml
ExcelToSql/App.xaml.cs
ExcelToSql/ExcelToSql.csproj
ExcelToSql/ExcelToSql.csproj.vspscc
ExcelToSql/ExcelToSql.sln
ExcelToSql/ExcelToSql.vssscc
ExcelToSql/Library/DocumentFormat.OpenXml.dll
ExcelToSql/Library/DocumentFormat.OpenXml.txt
ExcelToSql/Main.cs
ExcelToSql/MainWindow.xaml
ExcelToSql/MainWindow.xaml.cs
ExcelToSql/Properties/AssemblyInfo.cs
ExcelToSql/Properties/Resources.Designer.cs
ExcelToSql/Properties/Resources.resx
ExcelToSql/Properties/Settings.Designer.cs
ExcelToSql/Properties/Settings.settings
ExcelToSql/Sql/ExcelCreate.sql
ExcelToSql/Sql/ExcelDrop.sql
ExcelToSql/Sql/ExcelInsert.sql
ExcelToSql/Sql/ExcelInsertBegin.sql
ExcelToSql/Sql/ExcelInsertEnd.sql
ExcelToSql/Sql/NameCreate.sql
ExcelToSql/Sql/NameDrop.sql
ExcelToSql/Sql/NameInsert.sql
ExcelToSql/Sql/NameSelect.sql
Download
Click the following link to download excel2sql.zip.
excel2sql.zip