If we receive data in .accdb format periodically, and we name and store these files as YYYY-MM-DD.accdb in a folder. For doing diffs and trending analysis, is it possible to load these Access files without manually setting up OLE DB connections ahead of loading data?
Thanks.
Yong Jin