Well, there are a number of ways to work around this. I will throw some
choices and you choose whatever you like:

a) In the text file, run ""Find-Replace" and replace the , with blank
space. This way, when you use ; as delimiter, it will work. Then you can
run a small query to format the values in this column to a format that you
want to keep.
b) You can use a row delimiter {CR}{LF} .
c) If you are a developer, write a simple code that will pull the data from
text file, parse it and once entered, re-format it to the format you want,
ANY format you want.

Sanchan [MSFT]

sanchans (AT) online (DOT) microsoft.com

This posting is provided "AS IS" with no warranties, and confers no rights.