Hi all. Being new with MS Access, I don't quite know how to put together a macro for this requirement that I'm working on. I would really appreciate all the help that I can get. Here it is:
I need to create a macro that would allow me to:
1. look at the accountID on a csv file
2. match it with the accountID on the accountInfo table
3. grasp the partID from the accountInfo in the accountInfo table
4. update the partID on the csv file using the partID from the accountInfo table.
Thanks Rogue. I tried your suggestion by linking the csv and then create a new table for the csv (text file) - (is it the right way to link csv file?). But then I got stuck because I don't know how to do an update statement to join the new table with the existing table. I attempted to put together an update statement but I couldn't get it to finish. Can anyone please look at the update statement and give me advise or let me know if I'm on the right track or not. Thanks in advance.
Here's the update statement:
set field1 = (select accountID
where partID = field3)