Rearranging data in Access
I'm trying to input a large amount of data into Access, but instead of having one row for each result, the results are in a 2-dimensional grid, where each row represents a device being tested, each c...
Forum Discussion
Here's a simplified example of what the data looks like:
Each Excel file represents one lot
Each lot has several samples
Each sample has ~30 sites being tested
Each site is tested with up to 300 tests.
Based on your sample you need some work ( i assume that every Excel has similar structure)
Parse the Excel with Automation
Read the Lots (column) ...Group by ...these are inserted to the LOT table
Read the Sites(Column)........these as inserted to the Sites table
Read the Test Columns........these as inserted to the Test table
Read the Columns with the data these are inserted to the DataValue table
LotID SiteID TestID DataValue
I reckon that this probably could be a paid job