Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Computer Certification > Microsoft Certification > Read the data from Excel

Thread Tools

Read the data from Excel

Posts: n/a
I try to read the data from excel using the following

FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\ExcelData.xls";
User ID=Admin;Password=;Extended properties=Excel

the above gives me an error like
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' does not contain
table 'Sheet1$'. The table either does not exist or the
current user does not have permissions on that table.

2) select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;DATABASE=c:\ExcelData.xls', 'Select * from
The above gives me an error like
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an
[OLE/DB provider returned message: The Microsoft Jet
database engine could not find the object 'Sheet1$'. Make
sure the object exists and that you spell its name and the
path name correctly.]

...Please give me solution as soon as possible
Waiting for ur reply..Thank u

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
User Entered Data(Read Only Data) to Excel Md Rafiq Ruby 0 05-06-2009 04:01 PM
How to return an excel file or excel data from ASP.NET Anonieko ASP .Net 2 02-12-2008 07:03 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
read a excel sheet using aspose.excel sajithkahawatta ASP .Net 3 04-19-2007 02:54 PM
ExtenXLS loads data into Excel 2002 file but damages the Excel file. Java 1 11-21-2006 05:48 PM