I'm new to this forum, and to Access...Please have patience with me!!!
I have been tasked with setting up a DB in Access for Sales Lead tracking and Paying Commission.
We recieve an extract (csv) weekly from another DB, which has Sales Lead information, ie. Company, Name, last Call, Sales person ID, etc...
All I want to do is import this data weekly into my master DB, and Add the record if it does not exist,
Change the record if it has changed, or
Ignore the record if it is the same...
This should be very simple, but I can't seem to accomplish it.
Any ideas or input would be greatly appreciated.
Thanks, Erik
I have been tasked with setting up a DB in Access for Sales Lead tracking and Paying Commission.
We recieve an extract (csv) weekly from another DB, which has Sales Lead information, ie. Company, Name, last Call, Sales person ID, etc...
All I want to do is import this data weekly into my master DB, and Add the record if it does not exist,
Change the record if it has changed, or
Ignore the record if it is the same...
This should be very simple, but I can't seem to accomplish it.
Any ideas or input would be greatly appreciated.
Thanks, Erik