Hello,
I have 240 separate Access files (.accdb) that I need to combine into one master database. Each of the 240 Access files contains forestry data from a single forestry plot that was collected on a handheld GPS and then exported into an Access file via Trimble Pathfinder Office, hence the reason these files are not already combined. I've attached one blank file so you can see the structure.
Each Access file is identical, containing the same four tables (Plot Center, Small Plot, Tree, and Woody Debris). I have added a "Plot ID" field to each table in each of the 240 Access files and populated it with the unique forestry plot number (e.g. 21-13) so that when combined, it will be clear which data is associated with which plot. In the end, I would like the user to be able to search for individual plot data via query by "Plot ID", or use the entire database to conduct analyses (e.g. calculate average tree height, etc.).
I have read about merging or combining Access files by using the Import Wizard and then using an Append Query to append tables, however, with 240 files to work with and four tables per file, I imagine this will take a very long time! I am hoping to find someone who has a script or code I could use to streamline the process. I have never worked with scripts in Access, but have used them in R and FileMaker Pro.
Thanks in advance!
KelleyForestry_Database_Structure.accdb