Change dot to a comma in .txt file

  • Thread starter Thread starter Karin
  • Start date Start date
K

Karin

When importing a .txt-file to access, one of the column contents amounts with
a dot. Ig 253.53 instead of 253,53. How to change this in access? The amount
will not appear at all in the table.
 
hi Karin,
When importing a .txt-file to access, one of the column contents amounts with
a dot. Ig 253.53 instead of 253,53. How to change this in access? The amount
will not appear at all in the table.
Click to expand...
Depending on your settings you may use

CDbl([field]) when you need a number

or

Replace([field], ".", ",") when you need a string.



mfG
--> stefan <--
 
Back
Top