Split comma delimited text

  • Thread starter Thread starter ME
  • Start date Start date
M

ME

I imported a file from Excel that had a field that was
storing 3 values that need to be split into 3 fields.
The data is separated by commas, ex: 16,34,90.
I'm new at this so I'm not sure how to write the SQL
statement that will do this for me, especially in the
unlikely(but possible) case where there might be only 1 or
2 values in the field.
 
Rob,
Sorry but I am a total newbie here: Use VBA to split it
out in Excel first or after in Access? If you can give me
an example I'd really appreciate it. thanks.
 
I would probably split this in EXCEL before importing it. Excel has the
functionality to do this fairly easily.

IF you have to do it in Access, it can be done using VBA or with a query.

In Excel, SELECT the data
Then Select Data, Text to Columns...
Follow the wizard instructions.

You should have two empty columns to the right of the column you wish to split
into multiple columns.

If this solution is not good for you, post back and we can try to come up with
alternative solutions.
 
The power of knowledge! Thank you very much, the
Excel "text to columns" wizard worked great.
 
Back
Top