Search results
-
A
Difficulty splitting text string into multiple columns
Thank You arnelgp! You are the man! Thank you too to Markk and June7! Markk I hear what you are saying and will also look in to going down that path. -
A
Difficulty splitting text string into multiple columns
arnelgp thanks. I'm getting a syntax error on line Else If Len(strValue) <> 0 And intPartWanted = 1 Then -
A
Difficulty splitting text string into multiple columns
June7, thank you for chiming in. I tried your suggestion, but it didnt seem to change anything. Should I leave it like that or revert back to the code from arnelgp? -
A
Difficulty splitting text string into multiple columns
arnelgp thank you again! I think we are getting closer. The errors have disappeared and a field that had three strings split out ok, but a field that only had one entry didn't show up at all in the results. -
A
Difficulty splitting text string into multiple columns
Thank you arnelgp. I tried your code but it still throws that error and shows only part of the data when it finally completes. It -
A
Difficulty splitting text string into multiple columns
Thank you Markk! I agree that the data is not stored as well as could be, but it is what it is. This export/import then report process is something that has to be done periodically, not just a one in done and it will need to be done by administrative staff that will not have the time nor the... -
A
Difficulty splitting text string into multiple columns
I'm putting together an access database to be used as a reporting function for an online registration database. The online database exports its data into a csv which is then imported into MS Access. I have four fields that have from 0 to 5 strings of text separated by commas. I need to separate...