Hi,
I have an Access DB that tracks employee training. There are about 100 different training columns and I was given a list of employees (and employee id's prinmary key) that have completed First Aid training.
Besides exporting the data into excel then doing a vlookup on the SSN's to get the completed training dates for First Aid Then re-importing all of the data back into my Access DB, is there a way that I can have a VBA script or VB script pick up the txt file and update the First Aid training dates in my Access DB?
I have done alot of searching for an answer to this and cannot seem to find anything...
Any help/advice would be greatly appreciated!
Thanks!
I have an Access DB that tracks employee training. There are about 100 different training columns and I was given a list of employees (and employee id's prinmary key) that have completed First Aid training.
Besides exporting the data into excel then doing a vlookup on the SSN's to get the completed training dates for First Aid Then re-importing all of the data back into my Access DB, is there a way that I can have a VBA script or VB script pick up the txt file and update the First Aid training dates in my Access DB?
I have done alot of searching for an answer to this and cannot seem to find anything...
Any help/advice would be greatly appreciated!
Thanks!
Comment