Velocity Reviews - Computer Hardware Reviews

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

Reply
Thread Tools

Read the data from Excel

 
 
MAdhav
Guest
Posts: n/a
 
      07-14-2004
I try to read the data from excel using the following
queries

1) SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\ExcelData.xls";
User ID=Admin;Password=;Extended properties=Excel
8.0')...Sheet1$

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
[Sheet1$]')
The above gives me an error like
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an
error.
[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
Madhav



 
Reply With Quote
 
 
 
Reply

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. kp2900@gmail.com Java 1 11-21-2006 05:48 PM



Advertisments