J
Jason
Ok.. I have a complete working solution to not only scan a directory and import all files into a new table, but also to move all files into an "archive" subfolder after the import is done. This move -as opposed to a rename- was done for a couple of reasons:
1) To eliminate the chance of any update or appends creating duplicate data
2) To eliminate the possibility of a user to "not know" what file was what, how to open, etc
3) Keep the naming convention as-is
4) To process routines on that archive
I appreciate all of your help, and patience. Although I really didn't *completely* get a solution from this forum, certainly several ideas were introduced and I learned quite a bit from the methodology of all input from everyone. I totally thank all of you who had input in my issue... god knows, I will most likely ask something again. =p Prepare yourselves! hehe
~jason
1) To eliminate the chance of any update or appends creating duplicate data
2) To eliminate the possibility of a user to "not know" what file was what, how to open, etc
3) Keep the naming convention as-is
4) To process routines on that archive
I appreciate all of your help, and patience. Although I really didn't *completely* get a solution from this forum, certainly several ideas were introduced and I learned quite a bit from the methodology of all input from everyone. I totally thank all of you who had input in my issue... god knows, I will most likely ask something again. =p Prepare yourselves! hehe
~jason