I have a customer that sends me data to be imported into their Access 2003 database in the form of 3 seperate Excel files. Excel file #1 has allot of information about an employee (name, address, start date, last day worked, seperation code, and a number that corresponds to store worked at); Excel file #2 has supervisors information and the store number the supervisor is at; Excel file #3 has an explanation of what the seperation code means. I need to be able to import all of these files into the same table. The common fields between file #1 and file #2 is the store number/location. Now of course there will not be as many supervisors as employees. So I need to be able to match the supervisors store number to the employees store numbers and add that supervisors information to that employees record. And then the common field between file #2 and file #3 is the Seperation Code. So, if an employees seperation code is 323, and in file #3 seperation code 323 stands for quit, then I need to addd that description to that employees record.
Anyone got any insights into how I can possibly do this? I know it can be done because I saw an Access application once that did something like this only it used phone numbers to match the records and then appended the information to each record.
Thanks in advance for your help...
David
Anyone got any insights into how I can possibly do this? I know it can be done because I saw an Access application once that did something like this only it used phone numbers to match the records and then appended the information to each record.
Thanks in advance for your help...
David
