Click here to Skip to main content
15,305,430 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,

I have windows(C#) application in which i am importing data from excel sheet to the Sql server 2008 r2 database using providers are as below.

Microsoft.ACE.OLEDB.12.0
Microsoft.JET.OLEDB.4.0

Now, i did n't find any providers under providers node in sql server 2008 r2.

How to Add

VB
Microsoft.ACE.OLEDB.12.0
Microsoft.JET.OLEDB.4.0


in sql server 2008 r2?


Any help..

Thanks..
Posted

1 solution

Look for generic SQL Server or SQL Server Native Client 10 (I do not remember which).
   

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