I am trying to Load Excel data into Sql Server database through Tsql query.. But i am getting a error.
i use Sql Server 2008/2012 64 bit and microsoft excel 2010 32 bit.
i tried below methods
https://www.simple-talk.com/sql/t-sql-programming/questions-about-using-tsql-to-import-excel-data-you-were-too-shy-to-ask/
1. Created linked server, execute below store procedure
EXEC sp_tables_ex 'Linked_server_name'
I am getting error:
The 32-bit OLE DB provider "Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server.
Even other methods gives above error.
Please mention the steps to load the data from excel to sql server...
Mark as Answer if its helpful to you
---
Srihari