Morning all,
I am new to import via vba/access so its probably a basic question.
I have a current dbase, that could be updated daily if needed.
The dbase is small (only 7 fields), but the entries are in the 1000s.
I am looking for a way to update the current dbase by:
- If entries in the import file and dbase have the same Unique identifier (txtAppNo), then the entry is left as is except one field is updated with the new imports string (numCount).
- If import file has entry that dbase doesn't (therefore a new entry), then it imports a new entry to the dbase.
- if dbase has entry that import file doesn't, then do nothing.
Any thoughts or any good resources to start this process.
I have heard it is actually relatively easy and simple, but for a newbee I am struggling with where to start.
I am new to import via vba/access so its probably a basic question.
I have a current dbase, that could be updated daily if needed.
The dbase is small (only 7 fields), but the entries are in the 1000s.
I am looking for a way to update the current dbase by:
- If entries in the import file and dbase have the same Unique identifier (txtAppNo), then the entry is left as is except one field is updated with the new imports string (numCount).
- If import file has entry that dbase doesn't (therefore a new entry), then it imports a new entry to the dbase.
- if dbase has entry that import file doesn't, then do nothing.
Any thoughts or any good resources to start this process.
I have heard it is actually relatively easy and simple, but for a newbee I am struggling with where to start.