excel file reading error (adodb)

ccc_storage · August 21st, 2004, 06:38 AM

   Hi,
   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"
line:25 objRS.Open

==== 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.

bmains · August 22nd, 2004, 07:57 PM

Hey,

Try pro12_as$. Often when inserting into Excel, this is how it represents the spreadsheet name.

Brian