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.
 

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

Append Crosstab Query to Existing Table 0
Appending an existing table with imported Excel data 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
How do I clear a form? 0
Adding data to MS Access from csv file 0
How to import Start/Finish Data from Excel 1
How to modify and updte specific styles for specific paragraphs across the document 0
add mergefields to exsting word 2013 2

Top