Appending Table with no auto number to one with an Autonumber?

[stazza18]

I am currently trying to import an excel spreadsheet into my database. The problem is that I need primary key that is made up on an autonumber along with the imported information. Any ideas on how I can get this done? The import function keeps telling me I have to keep the table the same as the spreadsheet.

 

[sfreeman]

Are you doing this import manually, via a macro, or VBA?

 

[stazza18]

I was doing it was a transfer spreadsheet macro into a table.

 

[BNPMike]

Import the data into a temporary table. Then load the data into your target table.

 

[stazza18]

I was trying to do that but I can't seem to get the autonumber field to work with the temporary table. I keep getting errors when I append the temporary table to the permanent table that has the autonumber field.

 

[BNPMike]

Have a look at this in Help:

Change the starting value of an incrementing AutoNumber field

 

[ALEKSJAY]

I think you can import all the fields and left the autonumber out of the import so it fills itself.