Import Excel File (*.xlsx) into SQL

Copy huge amount of Excel files (*.xlsx) to SQL database for further processing, analysis and data validation. No schema changes required! This component runs also on servers where no Excel application is installed.

Every Excel cell can be uniquely identified by the FileName, SheetName, Row and ColumnName. And therefore queried with SQL, once loaded with this "Excel To SQL" component.

Excel2Sql.png

Requirements

  • .NET 4.5
  • SQL Server 2008 R2 or higher.

Last edited Oct 15, 2013 at 10:26 PM by danielsteiner77, version 11