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.