Hi friends
This is my stored procedure
alter procedure sp_excelfortest
as
declare @sql varchar(500)
set nocount on
begin
Set @sql ='select * FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',
''Excel 8.0;Database=D:\baskarbook1.xls;HDR=YES;'',
''SELECT * FROM [Sheet1$]'')'
exec (@sql)
end
This is works one time successfully.
but when i restart my sql server it display this error
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
I read some article about this error but i didnt get a exact answer for my problem.please help me
Loading
Javeed M ShaikhPosted Aug 24, 2012, 4:19 PM
http://blogs.msdn.com/b/spike/archive/2008/07/23/ole-db-provider-microsoft-jet-oledb-4-0-for-linked-server-null-returned-message-unspecified-error.aspx
http://dbaspot.com/sqlserver-programming/201234-openrowset-opendatasource-excel-2007-sql-2005-a.html