Thanks! That worked. However I have another problem. In the code that I originally posted, I had this SQL statement inserted in a loop and it doesn't seem to be working the way I want it to. I actually think I need two loops. One to continue to look at the SourceString and another so that it continues to insert the rest of the array values into [InjuryType2], [InjuryType3], etc.... I don't know if this makes sense, but I hope so. Thanks again.
Dim ParseString() As String
Dim SourceString As String
Dim strClaimNumber As String
I have another module that I run that imports data from an Excel Spreadsheet. Each record contains a field called [ClaimNumber] which is the primary key and another cone called [Injury Types]. The field contains a string of values separated by a semicolon (i.e. 22;26;28). Each number corresponds to a type of injurty that I list in another table "tblInjuryList".
So, what I'm trying to do in the code on this post is to parse out the Injury Types field and insert the values in a table "tblInjuriesperClaim" so that the data becomes "normalized".
There can be anywhere from 1 to 25 Injury types per claim.
Am I making this harder than it is? I am working on getting myself to a VBA class because I really have no support where I work!!! (Can you tell?)
Please let me know if you need additional information in this explanation. I will check in later, as I have to run right now.
thanks again for your help. don't know what I would do with this forum!