CSV file to overwrite selected fields in Access 97

G

Guest

I have a database on my web site that collects address info, but the Access
database on my computer that I use as my master DB contains those fields and
a host of other tracking information. I can get the info from my web site in
csv format. How do I import the most current data (the csv file) and map it
so the correct fields for each record overwrites the old data in the Access
database, without harming the data in the additional fields only found in my
master database?

I am not a programmer, so I'm looking for the easiest, simplest way
possible. THANKS!
 
J

Joe Fallon

This is not very simple to do at all.
I built a whole application around this idea.

One idea would be to import the csv data to a staging table named "NewData"
or something like that.
Then write an Update query to move the data over to the real table and
overwrite the fields that match the key values.
 

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

VBSript to read multiple CSV files & write out to 1 CSV file 13
Append csv or xls file to existing table 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Import web data or csv file from web server into access database. 1
Import fields from .csv with variable column structure 4
csv file creation 1
Create 1 .csv file from 3 tables of differing number of fields 1
Invalid Argument Error when importing .csv to Linked Table 1

Top