Importing from excel Auto number

[drusteeby]

I wrote some code so the user could push a button and import from excel, the problem is that my unique ID for my data is an autonumber and the data imported is not getting assigned one. How can I fix that?

DoCmd.TransferSpreadsheet transfertype:=acImport, TableName:=acTable, FileName:=Me.Text1, HasFieldNames:=True

 

[Alisa]

I think you might be able to do that using an import specification.