Unanswered: import fields of excel to fields in access?
I receive an excel file daily from one of my clients. The file contains terminated employees and their employment info. For instance, the file contains approximately 50 employees daily with the fields first day worked, last day worked, pay rate, reason for dismissal, first name, last name, and social security number, state and location code.
I want import the contents of this excel file, into the fields in an access database form. For instance, I have a form called "terminations" and I would like to import the termination file into my access database on a daily basis. So, when I receive my daily file I can just keep adding it to my database.
Can anyone provide me a step by step instruction as to how this would be done? Thanks for your help!