[AccessD] Why can't I import from Excel 2000

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/ *
**************************************


More information about the AccessD mailing list