juanthomas
New member
- Local time
- Yesterday, 18:10
- Joined
- Mar 8, 2010
- Messages
- 1
I am using MS Access 2007. I have created an Address Master Table (Master) from a .csv file.
I frequently get updates (new addresses or changes in address information) to the .csv file. To help with the import process, I created a temp table (tmpCSV); using compare queries I can identify any new records and append them to the "Master" table.
However, the addresses, or phone numbers may change for existing records within the "Master" table.
I want to build a query or VB code that will go through the tmpCSV table and identify changes within columns and then update only the records with changes.
Does anyone have any sample code or suggestions?
I frequently get updates (new addresses or changes in address information) to the .csv file. To help with the import process, I created a temp table (tmpCSV); using compare queries I can identify any new records and append them to the "Master" table.
However, the addresses, or phone numbers may change for existing records within the "Master" table.
I want to build a query or VB code that will go through the tmpCSV table and identify changes within columns and then update only the records with changes.
Does anyone have any sample code or suggestions?