Forum Discussion

Logaraj Sekar's avatar
Logaraj Sekar
Iron Contributor
May 13, 2017

Can not able to import Excel File into SQL

Hi Team,

 

I mostly working with Excel.

 

Some of excel files having large amount of data (Eg. Around 8 lakh rows and 52 Columns)

 

For getting some results, excel is hanging or taking more time and more functions.

 

But SQL is very fine to get results within seconds.

 

Problem is while importing excel file (Ver. 2007) it shows an error (Please find attached file)

 

But, It allows to import excel file of 97-2003 file format. i.e xls.

 

For getting result, i am saving "xlsx" file into  multiple "xls" files (Coz, xls having 65536 rows only)

 

Single "Xlsx" file of 8 lakh records saved as 16 "Xls" files contains 50000 records per file.

 

And importing them into MS SQL Server.

 

Solve this.

Analysis Services

1 Reply

  • Peter McDonald's avatar
    Peter McDonald
    Iron Contributor
    May 14, 2017
    Try downloading and installing the Microsoft.ACE.OLEDB.12.0 Data Provider that is part of the Microsoft Access Database Engine.

    Link:
    https://www.microsoft.com/en-us/download/details.aspx?id=13255

    The page here give more information about the process:
    https://social.technet.microsoft.com/wiki/contents/articles/24236.importing-an-excel-spreadsheet-into-a-sql-server-database.aspx

Resources