Query Excel

From: Mark (anonymous_at_discussions.microsoft.com)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 13:06:17 -0700

I am trying to query Excel data like this:
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
  'Data Source="c:\SupportRotation.xls";
   Extended properties=Excel 8.0')...[ Sheet1$ ]

All I get is the folowing:
erver: Msg 7314, Level 16, State 1, Line 1
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.
OLE DB error trace [Non-interface error: OLE DB provider
does not contain the table:
ProviderName='Microsoft.Jet.OLEDB.4.0', TableName=' Sheet1
$ '].