How do I import a text file that have number fields in European formats:
123.456,00


I can specify that a comma is the decimal separator using the Import/Export
specifications by there is not an option to specify that the “.” is the
thousands separator.

I would import it into a text field.

Next I would run an update query to replace all the periods "." with nothing
"" using the Replace function.

Then I'd run another update query, again using the Replace function, to
replace the comma "," with a period ".".

Then you could use the Val function to convert the text string to an actual
number as needed.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"mtatlow" wrote:

> How do I import a text file that have number fields in European formats:
> 123.456,00
>
>
> I can specify that a comma is the decimal separator using the Import/Export
> specifications by there is not an option to specify that the “.” is the
> thousands separator.
>