<html><div style='background-color:'><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*.</html>