how do I synchronize data with text file and Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an comma-separated file that I have imported into my Access Database.
That worked Fine!

How do I automate that process on a nightly basis? But also make sure that
the text file is just not overwritting data but actually synchronizing (Only
making database changes if comma-separated file has change.)

Example: I currently have a record with my personal data (name, address,
city, etc.) Assume that the address in the database is an old address. Now
When I run the import or in this case the synchronization, my new address
from comma-separated file will be updated in the Access Database?

Any help would be greatly appreciated. Even if I can get pointed in the
right direction.

Thanks,
Kevin
 
The only way I have found to do this type of work is to
use a temporary working table to hold the "new"
data/changes. Then create an update query to match the
temporary table to your "live" table and update the
fields. That will update records that already exist in
your "live" table.

If you need to add records to your "live" table, an append
query to find unmatched records works for me.

Hope this helps.

-----Original Message-----
I have an comma-separated file that I have imported into my Access Database.
That worked Fine!

How do I automate that process on a nightly basis? But also make sure that
the text file is just not overwritting data but actually synchronizing (Only
making database changes if comma-separated file has change.)

Example: I currently have a record with my personal data (name, address,
city, etc.) Assume that the address in the database is an old address. Now
When I run the import or in this case the
Click to expand...
synchronization, my new address
 
Back
Top