The scenario comprises the following tasks:
- Set up an import specification to allow Access to import the same data in future months.
- Use the built-in Table Analyzer tool to create a normalized structure for the data.
- Create a set of append queries that will parse the incoming data into the normalized structure.
- Write a macro that automates the data import process.