Click here to Skip to main content
15,906,766 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I need to copy excel file contents to a table . I did all the steps as per the below link


http://cleancode4devs.blogspot.com/2012/01/import-data-from-excel-to-sqlserver.html?showComment=1377771182537#c8347664234456576394[^]

but it is showing one error

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.


version details

sql 2012


Microsoft SQL Server Management Studio 11.0.3128.0
Microsoft Analysis Services Client Tools 11.0.3128.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.7601.17514
Microsoft .NET Framework 4.0.30319.17929
Operating System 6.1.7601
Posted
Updated 29-Aug-13 0:27am
v2
Comments
[no name] 29-Aug-13 6:21am    
Which version of SQL Server? And more precisely 32-bit or 64-bit SQL Server?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900