We need to add all records from 1 table to the end of another table.
Posted on 2011-10-31
I have two tables in a MS Access DB. Table A which is the main table has 15 fields. The second Table B currently has 10 fields. The first 10 fields are identical in size, order, heading, form, etc. in both tables. To end with only one table, we would like Table B to be appended to the bottome of Table A. (Duplicates are OK). When completed, the information +for the last 5 fields will be added manually. The autonumber field in Table A we want to keep. When the records from Table B are added to Table A, we want the sutonumber to assign numbers to them as if they were manually entered.
I think that the command to do this is:
Insert into table A select * from Table B
Is this correct? If so, where would I place this command and start it? I am using Access Version 7 in Windows. Also, what should I do with the autonumber field in Table B? Should both tables be open when this process is done? Note: The autonumbers in Table A are already referenced on reports, queries, etc. and we do not want the original numbers in Table A to change, if possible.
My biggest problem is finding where to place the processing code and how to run it.
Any assistance you can give will be greately appreciated.