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

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
>
>"Things are only free to the extent that you don't pay for them".-Don
>Elliker
>
>_________________________________________________________________
>STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
>http://join.msn.com/?page=features/junkmail
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail