By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,484 Members | 1,811 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,484 IT Pros & Developers. It's quick & easy.

Access Update Query from a Txt File

P: 5
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!
Feb 11 '08 #1
Share this Question
Share on Google+
1 Reply


MindBender77
100+
P: 234
One possible solution would be to create a macro that Imports the text file into its own table (TransferText). Next, in the same macro run an update or append query.

Bender
Feb 11 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.