Importing data to existing access tables

G

Guest

I want to import data to an existing table. I want to overwrite the data for
existing primary key records and append new records for those that do not
already exist. The standard import wizrd won't let me do this? Do I need to
write a macro to accomplish this?
 
D

Duane Hookom

Import the records into a temporary "holding" table and then perform your
updates and appends.
 

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 Date to Existing Table 1
Access Access 2010 import/append data into table w/o overwriting existing records 0
How to Create a Macro to Import External Data 0
Importing Data Error 2
Import Overwrite Data in Table 3
Importing Tab Delimited Text File to an Existing Table in Access 3
Importing data from excel spreadsheet 1
import data from excel 2003 to a table in an existing database 2

Top