importing a text file witnh european number formats

  • Thread starter Thread starter mtatlow
  • Start date Start date
M

mtatlow

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.
 
Back
Top