Download Excel sheets into contacts

[magster01]

I am new to the 2010 version and I am working on downloading contact sheets from excel into access. The download is complete and I see all the sheets and can filter, but my contacts page is still empty. How do I get the contacts from the different sheets into my contact list?
Thanks for the help.

[rpeare]

How did you import your data, did you use the transferspreadsheet method? If so you have you use the very last variable of the transferspreadsheet to indicate which worksheet you want to import, otherwise it always defaults to the first worksheet. Note you also have to follow the worksheet name with a $ to indicate you're importing an entire worksheet and not a range of cells.

docmd.TransferSpreadsheet acImport,spreadsheettype,DestinationTable,Originat ionFile,HasFieldNames,Worksheetname$

The bold part is where you have to put in your contacts worksheet name, and of course substitute all your object names where applicable.