Import - data to existing database

  • Thread starter Thread starter Boompa
  • Start date Start date
B

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.
 
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.
 
You must log in or register to reply here.

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

Importing data from another access database to an existing table 2
Import new data and replace old data in Access table. 4
problems importing a Paradox file into Access 2003 4
Import errors importing Text into existing table, header vs no hea 3
Exporting/Importing between databases 2
Import specific data from excel 6
Number Data Type Unavailable 1
Import data and update changed information 1

Back
Top