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

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