Import from excel to access with auto-numbered ID feild

[tina2]

I need to import thousands of records into an access database. the table I am importing to has an auto-numbered ContactID feild. I tried importing the data with the ContactID feild blank, but access left it blank too.

Am I attempting the impossible?

 

[GoDawgs]

Import the records into a temp table first...then run an append query to append them into the table (you don't need to specify anything for the autonumber field, it will just fill it in). Hope that helps.

Kevin

 

[palz]

thanks dude, you helped me a lot.