<html><div style='background-color:'><DIV>
<P>/gustav</P>
<P>Yes I did and that works fine. It turns out I will need to do it that way anyway because the workbook contains many worksheets. It is yet another Excel 'database' being converted to Access where it belongs. Now here's hoping there is something that resembles a key. <BR>_d<BR></P></DIV><BR><BR><BR>"Things are only free to the extent that you don't pay for them".-Don Elliker
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>Hi Don
<DIV></DIV>>
<DIV></DIV>>Have you tried linking the worksheet or named range?
<DIV></DIV>>
<DIV></DIV>>/gustav
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> > When attempting to import (thru import data wizard) I get this error "There
<DIV></DIV>> > is no object in this control" when I click OK (like a good user) the wizard
<DIV></DIV>> > opens , blank. If I click anything but 'cancel' I get "The expression you
<DIV></DIV>> > entered refers to an object that is closed or doesn't exist" - isn't this a
<DIV></DIV>> > fine how-do-you-do?? Something is broken?? I checked the references I have
<DIV></DIV>> > Visual Basic For Applications
<DIV></DIV>> > Microsoft 10.0 Object Library
<DIV></DIV>> > OLE Automation
<DIV></DIV>> > Microsoft Activex data objects 2.1 library
<DIV></DIV>> > Microsoft Excel 10.0 Object Library
<DIV></DIV>> > I even added the last one, with the same result
<DIV></DIV>>
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>Help STOP SPAM with <a href="http://g.msn.com/8HMIENUS/2731??PS=">the new MSN 8 </a> and get 2 months FREE*</html>