Load data from Excel file to Sql Server database

Posted by Sriharim under Sql Server on 11/3/2015 | Points: 10 | Views : 817 | Status : [Member] | Replies : 2
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...

---
Srihari



Responses

Posted by: Rajnilari2015 on: 11/3/2015 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

Up
0
Down
Try using the 64 bit driver (https://www.microsoft.com/en-us/download/details.aspx?id=13255 ). There are several references ( https://www.google.com/search?q=microsoft.ace.oledb%2064%20bit&rct=j ) for fixing the problem.

--
Thanks & Regards,
RNA Team

Sriharim, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriharim on: 11/5/2015 [Member] Starter | Points: 25

Up
0
Down
I can't install the drivers in the System.

Is there any other way, using BCP or Bulk Insert command.

When i use BCP or Bulk Insert command, i am getting 'codepage' error.

---
Srihari

Sriharim, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response