IMPORTING FROM EXCEL

[speedzon21]

I am trying to import two sheets from the same excel file into a single table in access. I am able to import either sheet into its own table, but I can't get them both into one table. I've checked over and over and all the field names are identical. Any ideas?

 

[famousb]

use:<br><b>DoCmd.TransferSpreadsheet acImport, 8, &quot;AccessTableName&quot;, &quot;FileAndPathName&quot;, 0, &quot;SheetName!StartofRange:EndofRange&quot;<br></b><br><br>and then repeat it with the second worksheet name.&nbsp;&nbsp;this should append to the same table as long as you specify the same AccessTableName.<br><br>check out the FAQs page for further detail, or let me know if you need more help.<br><br>brian <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>