What mechanism would I be able to read contents of a .dat file when it is created then apply to a database and delete or archive dat file?
Dat file Is created automatically and placed in a folder on network drive, however data grows at an exponential rate as a file is created every 20 minutes.
I have a excel sheet that extracts data but runs forever once data set gets too big.
I would envision this being collated in access then exported to my excel sheet.