Perhaps you already cover this somewhere but I would like to know how to take column headings from an Excel file and place them in a single Access field.

for Example:

In Excel:
Id     Q1     Q2         Q3
1      5       6         5
2      6       5         6
3      5       5         5

(ID is the foreign key; Q 1-3 values can be any number--in my case between 0 and 9)

to (Access)
ID    Question     Score
1        1           5
1        2           6
1        3           5
2        1           6
2        2           5
2        3           6
3        1           5
3        2           5
3        3           5

---

Reply from Richard Rost:

You would need to do this with action queries. Set up the table, then you'll need APPEND queries for each of your fields.