Excel to SQL without JET or OLE (Version 2)

Kelvin Armstrong

Rate me:

4.29/5 (5 votes)

5 Oct 2010CPOL4 min read

61.4K

4.9K

Import an Excel Workbook ".xls" or ."xlsx" into SQL without the use of JET or OLE

exceltodatabase.zip
- amule.ico
- ExcelLibrary.dll
- ExcelPackage.dll
- ExcelToDatabase.sln
- ExcelToDatabase.suo
- ExcelToDatabase
  - amule.ico
  - bin
    - Debug
      - ExcelLibrary.dll
      - ExcelPackage.dll
      - ExcelToDatabase.exe
      - ExcelToDatabase.vshost.exe
      - ExcelToDatabase.vshost.exe.manifest
      - ExcelToDB.dll
      - ExcelToDB.xml
      - Settings.dll
  - CmdArguments.cs
  - ExcelToDatabase.csproj
  - ExcelToDatabase.csproj.user
  - Program.cs
  - Properties
    - AssemblyInfo.cs
- ExcelToDB
  - bin
    - Debug
      - ExcelLibrary.dll
      - ExcelPackage.dll
      - ExcelToDB.dll
      - ExcelToDB.pdb
      - ExcelToDB.XML
  - ClassDiagram1.cd
  - ConnectionString.cs
  - Excel Handling
    - Event Arguments
      - ExcError_EventArgs.cs
      - ExcInfo_EventArgs.cs
    - Excel2007UpHandler.cs
    - Excel97to2003Handler.cs
    - ExcelBaseHandler.cs
    - ExcelDB.cs
    - IExcel.cs
  - ExcelToDB.csproj
  - ExcelToDB.csproj.user
  - obj
    - Debug
      - ExcelToDB.csproj.FileListAbsolute.txt
      - ExcelToDB.dll
      - ExcelToDB.pdb
      - Refactor
        
        ExcelToDB.dll
      - TempPE
    - Release
      - ExcelToDB.csproj.FileListAbsolute.txt
      - ExcelToDB.dll
      - ExcelToDB.pdb
      - Refactor
      - TempPE
  - Properties
    - AssemblyInfo.cs
  - SQLHandler.cs
  - stctMessageHandler.cs
  - SvrDbInfo.cs
- Settings
  - bin
    - Debug
      - ExcelLibrary.dll
      - ExcelPackage.dll
      - ExcelToDB.dll
      - ExcelToDB.pdb
      - ExcelToDB.xml
      - Settings.dll
      - Settings.pdb
  - obj
    - Debug
      - Refactor
        
        Settings.dll
      - ResolveAssemblyReference.cache
      - SettingData.csproj.FileListAbsolute.txt
      - Settings.dll
      - Settings.pdb
      - TempPE
  - Properties
    - AssemblyInfo.cs
  - SettingData.csproj
  - Settings.cs
  - SheetInfo.cs
- SettingsCreator
  - amule.ico
  - bin
    - Debug
      - ExcelLibrary.dll
      - ExcelPackage.dll
      - ExcelToDB.dll
      - ExcelToDB.pdb
      - ExcelToDB.xml
      - Settings.dll
      - Settings.pdb
      - SettingsCreator.exe
      - SettingsCreator.pdb
  - frmCreator.cs
  - frmCreator.Designer.cs
  - frmCreator.resx
  - obj
    - Debug
      - Refactor
      - SettingsCreator.csproj.FileListAbsolute.txt
      - SettingsCreator.csproj.GenerateResource.Cache
      - SettingsCreator.exe
      - SettingsCreator.frmCreator.resources
      - SettingsCreator.pdb
      - SettingsCreator.Properties.Resources.resources
      - TempPE
  - Program.cs
  - Properties
  - SettingsCreator.csproj
exceltodbeg.zip
- ExcelLibrary.dll
- ExcelPackage.dll
- ExcelToDatabase.exe
- ExcelToDB.dll
- ExcelToDB.XML
- Settings.dll
- SettingsCreator.exe

C:\Users\Ko2 Hunter\Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\obj\Debug\ResolveAssemblyReference.cache
C:\Users\Ko2 Hunter\Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\bin\Debug\Settings.dll
C:\Users\Ko2 Hunter\Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\bin\Debug\Settings.pdb
C:\Users\Ko2 Hunter\Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\bin\Debug\ExcelToDB.dll
C:\Users\Ko2 Hunter\Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\bin\Debug\ExcelLibrary.dll
C:\Users\Ko2 Hunter\Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\bin\Debug\ExcelToDB.pdb
C:\Users\Ko2 Hunter\Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\obj\Debug\Settings.dll
C:\Users\Ko2 Hunter\Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\obj\Debug\Settings.pdb
C:\Users\Ko2 Hunter\Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\bin\Debug\ExcelPackage.dll
C:\Documents and Settings\adminkelvin\My Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\bin\Debug\Settings.dll
C:\Documents and Settings\adminkelvin\My Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\bin\Debug\Settings.pdb
C:\Documents and Settings\adminkelvin\My Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\bin\Debug\ExcelToDB.dll
C:\Documents and Settings\adminkelvin\My Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\bin\Debug\ExcelPackage.dll
C:\Documents and Settings\adminkelvin\My Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\bin\Debug\ExcelLibrary.dll
C:\Documents and Settings\adminkelvin\My Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\bin\Debug\ExcelToDB.pdb
C:\Documents and Settings\adminkelvin\My Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\obj\Debug\ResolveAssemblyReference.cache
C:\Documents and Settings\adminkelvin\My Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\obj\Debug\Settings.dll
C:\Documents and Settings\adminkelvin\My Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\obj\Debug\Settings.pdb
C:\Documents and Settings\adminkelvin\My Documents\Visual Studio 2008\Projects\ExcelToDatabase\Settings\bin\Debug\ExcelToDB.xml

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Kelvin Armstrong

United Kingdom

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Excel to SQL without JET or OLE (Version 2)

License

Comments and Discussions