I have a text file with many fields. I need to import one of the fields into an existing table in access. This process needs to be done daily.
what would be the best way to do this?
Thank you.
Printable View
I have a text file with many fields. I need to import one of the fields into an existing table in access. This process needs to be done daily.
what would be the best way to do this?
Thank you.
Create a small app to be run via windows task scheduler. App will implement code in link http://www.vbforums.com/showthread.p...ght=csv+select. I suggest you simply rename file (append timestamp to extension) in order to keep track which files have already been uploaded (upload only those with .txt extension). Fixed locations (mdb and text files) would facilitate processing (no need to read configuration file).