johnfli said:
How can I merge data from one table to another?
I have one table in Access that is Tied to my SQL server.
I have another table that is purely access. SSome of teh field
names are different, so I will need to be able to tell it what field
equal what field in SQL.
How do I do this?
Do you mean that you want to append the records from one table to the
other? You would do this with an append query. In the database window,
select the "source" table and then click menu items Insert -> Query (or
use the "new object" toolbar button to do the equivalent). In the
resulting "New Query" dialog, select "Design View" and click OK.
The Query Design window will open, with your source table displayed in
the upper pane. Click menu items Query -> Append Query..., and in the
resulting "Append" dialog, enter the name of the table you want to
append to and click OK. Then drag all the fields you want to copy from
the source table in the upper pane to the field grid in the lower pane.
Those fields that have matching fields with the same name in the target
table will automatically have the target field name entered in the
"Append To:" line of the field grid. For the remaining fields, enter
the name of the target field on the "Append To:" line under the source
field.
When you're done fixing up the fields, run the query. If you think you
may want to run this query again, save it as a stored query; otherwise,
just discard it.
