[AccessD] Phun with Excel / automation

Once the Import Spreadsheet Wizard starts you should see two radio button 
(Show Worksheets and Show Named Ranges).  Make sure the Show Worksheets 
one is checked and then you should see a list of the worksheets within 
your file.  Then just select the one you want to import and keep answering 
the wizard's questions.  Repeat the process for each worksheet to import.




"Don Elliker" <delliker at hotmail.com>
Sent by: accessd-bounces at databaseadvisors.com
06/12/2003 10:46 AM
Please respond to accessd

 
        To:     accessd at databaseadvisors.com
        cc: 
        Subject:        [AccessD] Phun with Excel / automation


Folks,
I am trying to import ,on a one time basis , the data from an excel 
workbook into Access XP. I can't use the 'import data' option, it only 
gets me the first worksheet (or am I doing it wrong?). I can get to the 
workbook in code easily enough but there seems no easy way to get the 
individual worksheets imported into separate tables. I tried using the 
'transferspreadsheet' docmd thingie, but it gets hung up on the file name. 
I cannot just reference the worksheet object- it doesn't like that. I 
thought it was working out too easily...#-(  - Sooo...does anyone have 
this experience...this is a one-off I just want the data in tables.
"Things are only free to the extent that you don't pay for them".-Don 
Elliker 

Add photos to your e-mail with MSN 8. Get 2 months FREE*._______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030612/74b35cff/attachment-0001.html>