I need some programming help with a problem. I have a delimited text file that have to update all records in an Access table. Hereís what Iím looking for: The Text file is an employee data file with updates or changes in status, address, salary etc., for all employees (7,000 records in the file). I need a code written to change the Access employee Table with the information found in the Text file. The unique identifier is the SSN#. How can I write a code that will take the information from the Text file to change or update or replace the employee Table file? Plus I need it to put in new employees and delete employees that not found in the Text file but is in the Table file.
Please help. The last time I written a code it was in COBOL.