Hello,

Here is my challenge:

I want to instert records from table 1 to table 2 using the following code: (Using Access Tables)

db.Execute " Insert INTO [Table2] " _
& "IN """ & OtherDB & """ Select [Table1].* FROM [Table1]"

The problem is that the primary key in these tables is an autonumber field. Help says to exclude the autonumber field if I want it to issue a new number when I insert. How can I exclude the column w/out having to state "Select col1, col2, etc"?

Is this possible?

Any suggestions are greatly appreciated!