script or method to unzip files deposited daily in a folder and load to an access table
Posted on 2012-03-21
I have a need to achieve the following:
load information from a file "abc1.dat.zip" into an access database
There is a new file deposited everyday. Presumably the naming convention will be standardized and incremented by 1
The files are not cumulative and, thus, need to be appended to the whatever information is already existing in the database table.
would it be preferable to unzip the files and combine them OUTSIDE of access and link to THAT file
Unzip the latest file and append that information to the existing access table.
This is a windows environment...
I hope I am explaining this properly and any assistance is greatly appreciated.