[AccessD] Phun with Excel / automation

Don,
If this a one time requirement you can import Excel worksheets through "Get
External Data" under File on the Menu bar.
It will give you an opportunity to list the Excel workbook.  You will have
to get each worksheet separately. The workbook needs to open to the desire
worksheet. 
HTH
Jim

-----Original Message-----
From: Don Elliker [mailto:delliker at hotmail.com]
Sent: Thursday, June 12, 2003 10:47 AM
To: accessd at databaseadvisors.com
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. <http://g.msn.com/8HMCENUS/2746??PS=>
Get 2 months FREE*. 

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