Importing data to existing access tables

B

BWS

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.
 
Top