Importing eExcel records with data on separate lines into one Access record

[bgammon]

Help, please!

I am trying to get information that appears on multiple lines in an Excel spreadsheet into one record in an Access table. Example:


Line Column A Column B
1


2
3
4 Question Number 4.5.6
5 Question Answer [Data that would go into a long text field for the first record]
6
7
8
9 Question Number 4.5.7
10 Question Answer [Data that would go into a long text field for the second record]
11
12....same pattern several times....


In the above example, after importing records, I would have two separate records, with different values in the question number and question answer fields.

Any thoughts/suggestions? Sure would appreciate it!

Bob

[ranman256]

you could add another field C (Q#)
line 4 , = 1 (question 1)
line 5, = 1
line 9 = 2
line 10 = 2

import , append all QUESTIONS (col A) into table
then 2nd update query to the [answer] field, match col C to the table and import ANSWERS, where matching on col C.

[bgammon]

Thank you, sir: I will give this a try.