Hi All,
Firstly apologies - I've never really worked with Access (I'm more of an Excel human).... I have been given the below problem and am pulling my hair out in large bunches so any assistance would be greatly appreciated.
I have a master file (csv) that will contain data in rows that needs to be used for outbound calling, the rows have a unique identifier and the master file needs to be updated with outcomes (which will be reported on daily). I have managed to get the data from our phone system to replicate all the fields / values per the master file.
I am trying to figure out a way of appending the new information onto the existing rows without deleting what is already within the master file. For example, we may try and contact a customer on day 1 but are unable to get through - this information will be on our daily report. We would try again the next day so would want the information to go into the relevant columns for that day (but not delete or overwrite the previous information)
I assume that this is something that is achievable in Access I just don't really know what i'm looking for. If you're aware of a similar thread / link to a webpage (anything)!
Thanks in advance,
Naides
Bookmarks