Importing numbers from text file

[Brotha Lee]

Hi all,

I have a text file in which one column contains number in the following
format:
1.000,00. My regional settings are US (1,000.00). When I am importing the
file, the numbers >1000 will not be imported. (I have changed the importing
setting to have the comma seperator set to , instead of .).

I tried to figure it out, but without succes. Can anybody please help me on
this matter.

 

[Klatuu]

My guess is that your text file is comma delimited, that is, each field is
separated by commas. When there are commas in the numbers, it confuses
Access, because it thinks the comma means the next field is starting.
If it is possible to create the text file using a different delimiter, that
would work. Also, if you have the capability to create the text file with
text enclosed in " then that will help. It would also be a good idea to set
up an import spec for the file.

 

[Brotha Lee]

Unfortunately this is not the case. It is a CSV file with ";" delimiter. Also
text is enclosed in ".