excel file reading error (adodb)
I am trying to read excel file with ADODB (with DSN) my connect going file
but when my ADODB.Recordset open it give me following error
========== code =========
line:24 objRS.Source = "Select * from pro12_as"
==== error =============
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find the object 'pro12_as'. Make sure the object exists and that you spell its name and the path name correctly.
/proswimmer/read_file2.asp, line 25
==================== end error =========
here pro12_as is my excel datasheet name
Please clear me, where i am wrong.