Importing Data problem
It will tend not to split at a comma if this falls within a text field
enclosed in quotes, but will split otherwise. It gets more complicated if
the field also contains quotes, so if you save as a cvs Excel will double up
the quote marks in this situation.
--
David Biddulph
"Testing" wrote in message
...
There does happen to be a ", space" immediately before where the data
splits
but there are hundreds of those all throughout the data and it doesn't
happen
in those places.
"DaveO" wrote:
I've seen this happen in a text field when the field contains a
punctuation comma that the import perceives as a delimiter. If you
look at the raw file, does that string contain a comma?
|