Hi All, I'm new to this forum and hope you could help me with a problem.
Situation is like this; I have an imported excel file which contains two parts. The first got “main” information about a project and are normalized. The second lists the time each person has worked. For this part the column heads have names that I need to use as data, this is the un-normalized data.
The below describes it;

Instead of having
Project date1 date2 date3
xxxxxxx 12 13 14

I want something like
Project date hours
xxxxxxx 1 12
xxxxxxx 2 13
xxxxxxx 3 14

This part is of arbitrary length due to the length of the current project, hence # of columns is arbitary.

The excel file should be imported to the same table every time (Import) and then direct the first part to tblBudget and the last part to tblTime. The first part I got right, I used an append query where a fixed mapping is performed. But how to map the last part to tblTime, i.e how to map an arbitrary amount of column headings to be records in another table?

I've thinking of two solutions to this;
imposrt the Excel table and load the first record of the table to find out the column headers to find the date.
Then run queries for each column to add the value + date + project # into my table tblTime. Rince and repeat that for all the columns where there is a value in the header record... But this seems complicated and I'm not sure of how to pull it off!

The other suggestion is to,
1) Direct the first part to tblBudget (as earlier through an append query)
2) Use some kind of query to delete the first columns
3) Perform a transpose (linear algebra) of the remaining part.
4) Direct the outcome to tblTime

But now I wounder if 2) is possible? And furthermore, how does it look “under the shell” of Access? Are the tables organized as a matrix with columns and rows as arrays? In that case it would be possible to do the transpose. If not, this idea halts at 3).

Would be very grateful if someone could give me guidence through this.

Cheers!