Creating a table with multiple records parsed out of a single long string of data

[fredalina]

Hi, I was given a table that has a long string that consists of "chunks" of items of data separated by a semicolon. For example: [1111-AA-222; 1112-AB-333; 1113-BB-999]. I need to create a table or query that contains one of the other fields (Project number) and then one row for each "chunk" of data in the long string. So the table would look like this:

ProjectNumber / Item
12345 / 1111-AA-222


12345 / 1112-AB-333
12345 / 1113-BB-999
98765 / 2222-ZZ-999
98765 / 2224-YY-888

I have no problem creating the code to parse the Items out of the long string and into an array. The problem is I don't know how to get it into a table (or query) once I do.

Can you help?

[ssanfu]

Use an append query to insert the data into the proper table.
Something like (Air code):

sSQL = "INSERT INTO MyTable (ProjectNumber, Item) VALUES (" & pProjectNum & ", '" & pItem & "';)"
CurrentdB.Execute sSQL, dbfailonerror

"ProjectNumber" would probably be a FK field.

Would have to see your code and/or know more about your dB to give a better answer.