I need to take information from a comma delimited text file and import, compare, replace and remove information into an MDB file.
A company will be updating the TXT file twice a day and they need that information to be placed in the MDB file without having duplicate records. The information from the TXT file information is the master, so if any information changed on the MDB file the TXT file will correct it. There is one column of information that must not be touched by the import and update process. All columns in the MDB file are text fields. I need it to be controlled by a program that allows the user to choose what TXT file will update what MDB file, control over the linked fields (what field updates what column), and I need to have control over how often it updates (ability to run unmanaged in scheduler)
Please respond with information on price and turn around time we are in need of this ASAP.
Thank you,
Bryant Followell