On Jan 5, 6:54*am, Volker Jordan
wrote:
"JP Ronse" wrote:
Hi,

What do you mean with "not possible toopena csvfile"? Can't youopenthe
file, is the parsing not corect or is the retrieved data not correct?

I canopenthefile, but all values with leading 0 e.g. telephone numbers
are gone.
0695155 - 695155. I have to declare some fields astext.

AFAIK, it depends also on your locale settings, e.g. separator is set to ";"
and thefileis using "," or vice versa or another character. How is the
fileopened when you do it manually?

Its the same. Manually the 0 are converted to numbers.

No, You can not import a .csv file with all columns defined as text
because Excel is trying to be helpful and defining what looks like
numbers as numbers.
I know of two ways to handle this.
Change the .csv to .txt
Insert a single quote ' as the first character in these fields forcing
Excel to handle as text.

Mike