Import - data to existing database

[Boompa]

I could not find any help on importing data into an
existing database. What I want to do is:

- Merge the new file to the old by the record key
- For identical fields, replace the data fields in the old
file with the new data.

 

[Douglas J. Steele]

Take a look at http://support.microsoft.com/?id=208870

Where it talks about Shippers1, substitute your existing table. Import your
new data into a table that's identical to your existing table, and use that
new table where it says Shippers2 in the example.