Giri Sain

Giri Sain

  • NA
  • 28
  • 3.4k

How to import excel data into table using sql query.

Mar 17 2022 6:09 AM

 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.


Attachment: Error_query.zip

Answers (4)