I am importing a sheet from excel into an existing access table. The table has to have an autonumber to work with sharepoint. My import selects an excel sheet because I have an indexed range and access doesn't recognize that. I have a query that clears the existing table in access, then imports the sheet from excel. When I do that I have the 3 records that should import and the autonumber field goes all the way to 6700. Any suggestions?