Load data from Excel file to Sql Server database

Posted by Sriharim under Sql Server on 11/3/2015 | Points: 10 | Views : 1482 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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. Mark as Answer if its helpful to you --- Srihari Sriharim, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts