Carlos Alberto Alves
caa at highway.com.br
Wed Jun 11 17:03:18 CDT 2003
On Tue, 10 Jun 2003 13:15:31 -0400, Don Elliker <delliker at hotmail.com> wrote: > Latest is 2.7 I unchecked 2.1 and check 2.7 - no change. > > <br><br><br>"Things are only free to the extent that you don't pay for > them".-Don Elliker > > > >> Why would you be using ADO 2.1 with Access XP? The installed version >> with XP is at least 2.5 or 2.6, if I remember correctly (I've got the >> latest version installed, so I can't check). Try changing to the latest >> installed version of ADO and see if it makes a difference. >> >> Charlotte Foust >> >> -----Original Message----- >> From: Don Elliker [mailto:delliker at hotmail.com] >> Sent: Tuesday, June 10, 2003 8:45 AM >> To: accessd at databaseadvisors.com >> Subject: [AccessD] Why can't I import from Excel 2000 >> >> >> When attempting to import (thru import data wizard) I get this error >> "There >> is no object in this control" when I click OK (like a good user) the >> wizard >> opens , blank. If I click anything but 'cancel' I get "The expression >> you >> entered refers to an object that is closed or doesn't exist" - isn't >> this a >> fine how-do-you-do?? Something is broken?? I checked the references I >> have Visual Basic For Applications Microsoft 10.0 Object Library OLE >> Automation Microsoft Activex data objects 2.1 library Microsoft Excel >> 10.0 Object Library I even added the last one, with the same result >> Hi People! I think Excel 2000 library is "Microsoft Excel 9.0 Object Library". Check out that XP installation changes libraries from v9 to v10. ;-) -- ************************************** * Carlos Alberto Alves * * Child Neurologist * * Systems Analyst/Programmer * * Rio de Janeiro, Brazil * * mailto:caa at highway.com.br * * http://igspot.ig.com.br/forefront/ * **************************************