How to import excel data into table using sql query.

Giri Sain

Query :

" SELECT * INTO tbl_TheIconic_Product FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=D:\Partnerize_Products_Files\THE_ICONIC_NEW.xlsx',
'SELECT * FROM [Data$]') "

Error :

Msg 7438, Level 16, State 1, Line 45
The 32-bit OLE DB provider "Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gajendra Jangid4y ago
use below link

https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-data-from-excel-to-sql?view=sql-server-ver15#:~:text=Import%20data%20directly%20from%20Excel,the%20SQL%20Server%20Database%20Engine.
+1
Jignesh Kumar4y ago
I think, if you have excel then no need to write query to insert. you can insert using import wizard. Please follow this thread,
https://www.c-sharpcorner.com/article/how-to-import-data-from-excel-data-into-sql-table/
+1
Giri Sain4y ago
Still same error on this query :

Msg 7438, Level 16, State 1, Line 1
The 32-bit OLE DB provider "Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server.
+1
Muhammad Imran Ansari4y ago
You don't have 64-bit driver installed on your machine, get driver from the following link for 64-bit.
https://www.microsoft.com/en-us/download/details.aspx?id=13255

Once get the copy, install it using the command prompt like:
"C:\Users\youuser\Downloads\AccessDatabaseEngine_x64.exe" /passive
Please make sure, you run command prompt as Administrative.
Here, the '/passive' switch is the key to prevents the installation from failing if you already have the 32-bit version installed (via 32-bit Office).
+1