Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 21st, 2004, 06:38 AM
Authorized User
 
Join Date: Aug 2004
Location: , , .
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default excel file reading error (adodb)

   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.
 
Old August 22nd, 2004, 07:57 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hey,

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

Brian




Similar Threads
Thread Thread Starter Forum Replies Last Post
Error reading data from excel to sql using ASP m_soni21 Classic ASP Professional 1 June 17th, 2008 12:40 AM
Reading an Excel file abhishekkashyap27 C# 2005 1 June 3rd, 2008 02:01 AM
reading excel file in java uttam.mca Pro JSP 1 July 14th, 2006 07:29 PM
Working with Excel Worksheet as ADODB.RecordSet Sebastiaan Classic ASP Basics 2 May 25th, 2004 03:10 AM
reading excel file msrnivas .NET Web Services 0 February 9th, 2004 06:31 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.