I export data from a system in the format shown in Table 1 (and I cannot change this format).
In order to import the data into Access I use Excel to transform it to the format shown in Table 2.
Once in Access, I then update each record with additional fields (SubGroup1 etc), as shown in Table 3.
I would like to avoid having to transform the data. So two questions:
1. Is there a way I can import the data in Table 1 format into a format in Access that I can then manipulate?
2. When I'm importing data into Access, can I use a run-time prompt for the data, which then becomes a field in my target Access table?
Any advice on this would be gratefully received.