<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1126" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=421121316-12062003><FONT face=Arial color=#0000ff
size=2>Don,</FONT></SPAN></DIV>
<DIV><SPAN class=421121316-12062003><FONT face=Arial color=#0000ff size=2>If
this a one time requirement you can import Excel worksheets through "Get
External Data" under File on the Menu bar.</FONT></SPAN></DIV>
<DIV><SPAN class=421121316-12062003><FONT face=Arial color=#0000ff size=2>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. </FONT></SPAN></DIV>
<DIV><SPAN class=421121316-12062003><FONT face=Arial color=#0000ff
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=421121316-12062003><FONT face=Arial color=#0000ff
size=2>Jim</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Don Elliker
[mailto:delliker@hotmail.com]<BR><B>Sent:</B> Thursday, June 12, 2003 10:47
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Phun with Excel / automation<BR><BR></FONT></DIV>
<DIV>
<DIV>
<P>Folks,</P>
<P>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.</P>
<P>"Things are only free to the extent that you don't pay for them".-Don
Elliker </P></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV></DIV><BR clear=all>
<HR>
Add photos to your e-mail with <A
href="http://g.msn.com/8HMCENUS/2746??PS=">MSN 8.</A> Get 2 months FREE*.
</BLOCKQUOTE></BODY></HTML>