excel query problem

hi everyone:

i have an asp page where i have to read an excel file and upload a
worksheet named "Tarifa" to a table in a sql server database.

the problem is that sends me this error:


Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could
not find the object 'Tarifa$'. Make sure the object exists and that you
spell its name and the path name correctly

the connection string is:
Driver={Microsoft Excel Driver
(*.xls)};DriverId=790;Dbq=C:\tarifas.xls;DefaultDir=c:\;

and the query im using is:
SELECT [Tarifa Seguros Atlas SA], F2, F3, F4, F5, F6, F7, F8, F9, F10,
F11, F16, F17, F18 FROM [Tarifa$] WHERE not isnull([Tarifa Seguros Atlas
SA])

i'm certain that the "Tarifa" worksheet exists.

anyone have had this problem before? any ideas how to resolve it?

thanks in advance..

*** Sent via Developersdex http://www.developersdex.com ***

Re: excel query problem

just guessing

the error goes


>could not find the object 'Tarifa$'

and you wrote
.....
> F11, F16, F17, F18 FROM [Tarifa$] WHERE not isnull([Tarifa Seguros Atlas
.......
maybe it should be
....
F11, F16, F17, F18 FROM [Tarifa] WHERE not isnull([Tarifa Seguros Atlas
......
just guessing


"Miguel Martinez" wrote in message
news:eITxxsu5FHA.2888@tk2msftngp13.phx.gbl...
>
> hi everyone:
>
> i have an asp page where i have to read an excel file and upload a
> worksheet named "Tarifa" to a table in a sql server database.
>
> the problem is that sends me this error:
>
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
>
> [Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could
> not find the object 'Tarifa$'. Make sure the object exists and that you
> spell its name and the path name correctly
>
> the connection string is:
> Driver={Microsoft Excel Driver
> (*.xls)};DriverId=790;Dbq=C:\tarifas.xls;DefaultDir=c:\;
>
> and the query im using is:
> SELECT [Tarifa Seguros Atlas SA], F2, F3, F4, F5, F6, F7, F8, F9, F10,
> F11, F16, F17, F18 FROM [Tarifa$] WHERE not isnull([Tarifa Seguros Atlas
> SA])
>
> i'm certain that the "Tarifa" worksheet exists.
>
> anyone have had this problem before? any ideas how to resolve it?
>
> thanks in advance..
>
> *** Sent via Developersdex http://www.developersdex.com ***