View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Volker Jordan Volker Jordan is offline
external usenet poster
 
Posts: 4
Default Workbooks.OpenText Method / FieldInfo

"JP Ronse" wrote:

Hi,

What do you mean with "not possible to open a csv file"? Can't you open the
file, is the parsing not corect or is the retrieved data not correct?

I can open the file, but all values with leading 0 e.g. telephone numbers
are gone.
0695155 - 695155. I have to declare some fields as text.

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

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