Hi i used the following query to import from excel
SELECT * INTO XLImport3 FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=D:\A G Edwards_2008-07-14_Weekly.xls;Extended Properties=Excel 8.0')...[ag$].
this query works fine

but when i tries to skip the rows and run the following query

SELECT * INTO XLImport3 FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=D:\A G Edwards_2008-07-14_Weekly.xls;Extended Properties=Excel 8.0')...[ag$A2:Z2000]

Error message
Msg 7314, Level 16, State 1, Line 2
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" does not contain the table "ag$A2:Z2000". The table either does not exist or the current user does not have permissions on that table.

Will anybody help me in resolving the issue