D
David G
Hi
I have a large amount of data in text files that I wish to append to a table
in Access. I did a manual link to the text file, set and saved some
specifications and successfully appended the data to my table. The problem
is I have a large number of text files (all the same specifications) that I
wish to append to the same table but I really don't want to do this manually.
I am hoping someone could point me to some VBA code that I could use to
automate this process? The other thing is the files are grouped in different
folders (Monthly folders with daily files) so I need something that could be
flexible enough to handle that, could someone assist me with this please?
I have a large amount of data in text files that I wish to append to a table
in Access. I did a manual link to the text file, set and saved some
specifications and successfully appended the data to my table. The problem
is I have a large number of text files (all the same specifications) that I
wish to append to the same table but I really don't want to do this manually.
I am hoping someone could point me to some VBA code that I could use to
automate this process? The other thing is the files are grouped in different
folders (Monthly folders with daily files) so I need something that could be
flexible enough to handle that, could someone assist me with this please?