Read and Import Excel Sheet into SQL Server Database in ASP.Net

Hi,

I used your code that you post on the link below.

http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASP.Net.aspx

I'm getting the following err

"The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"."

I follow all your solutions to solve this issue but none help. Im running SQL 2005 on Windows SBS 2003 server.

Also on solution 3 you runing the below sql query

Do i need to run it on the master database or on my database?

Thank you

USE [master]  

GO  

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1  

GO  

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1  

GO