Good Morning All,
I’m required to hook up to an enterprise wide system (we have 43000 employees, so I’m outnumbered) and they have some fields with varying amounts of concatenated data.

Fortunately there is a pattern.

All of the date is separated by “,” and all of it has 3 characters.

The problem is that there could be one of these groups or 20, and any number between.

I want to turn this into a daughter table with each of these sub-packets a new record.

Is there some kind of little (easy to write) loop that would extract them and append them to a new table?

Thanks in advance.

Look into the Split() function. You can open a recordset on the table and loop through the records. Within that loop, use the Split() function to break the concatenated field into an array and in a For/Next loop of that array, append values into your new table.