December 9, 2009 at 3:02 am
Hi all,
I want to select data from the fallowing excl2007 sheet form my server system
like....
select * from OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=D:\Sitecategories\sitepages.xls;Extended Properties=Excel 8.0')...[Sheet1$]
But it gives error like
Server: 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)".
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".
December 9, 2009 at 7:04 am
Are you running SQL Server 64-bit? There is no 64-bit driver currently.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 11, 2009 at 3:00 am
thanks for your reply,my problem was solved.I was restarted my server then that query gives result.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply