Copying Data from One Table to Another Copy the February trips from tblTrips into The command you learned about in Chapter 2 can Insert tblFebTrips also be used to copy data from one table to another. The two tables must be of similar structure but the (like “%-02-%”) field names or even the field have to be sizes don’t the same Errors could occur if field sizes are different new numbers will Don’t include auto number fields; be assigned to the inserted record automatically. Note: this could cause problems if the table needs to be linked with others. Insert Into tablename or * Select fieldlist From tablename2 [Where condition] The clause is optional. If it is omitted all Where records from the source table are copied to the destination table.
Copying Data from One Table to Another The Insert command you learned about in Chapter 2 can also be used to copy data from one table to another. The two tables must be of similar structure but the field names or even the field sizes don’t have to be the same Errors could occur if field sizes are different Don’t include auto number fields; new numbers will be assigned to the inserted record automatically. Note: this could cause problems if the table needs to be linked with others. Insert Into tablename Select fieldlist or * From tablename2 [Where condition] The Where clause is optional. If it is omitted all records from the source table are copied to the destination table. Copy the February trips from tblTrips into tblFebTrips (like “%-02-%”)