I receive excel files from multiple sources each month. Mainly it covers the same items, and I have to look for changes, i.e. have items been added or removed?
I want to set Access to import from a form button, appending to the existing table. To separate by month, as is the request, can an Assess query find the date data was added, say with the date() function, then set that date as a static number that never changes?
I was doing this manually with excel, but I was separating everything out using a folder structure and appending the folder name (Jan, Feb, ext.), using a Data Validation selection.
I am pretty new to Access, so I am sure there is a simple solution.