How do I move a record from one table to another in Access

H

HMK

the record I need to move from one table has different field names than the
table I need to move it to how do I map which fields to copy all the data
into the correct fields/columns in the new table?
 
K

KARL DEWEY

Create your append query in design view by pulling down the field names and
then selecting which field they go to. Just make sure the datatype matches
or convert the data first.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Setting column width in a table with a macro is not working 0
Format column widths from one table to a separate table on same page 1
Add additional information to excel form after original data entry 0
Merging from an Excel file with graphics 1
Copy previous record into form field 0
Append Crosstab Query to Existing Table 0
Help creating a search form in Access XP 0

Top