Change dot to a comma in .txt file

[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.

 

[Stefan Hoffmann]

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.

Depending on your settings you may use

CDbl([field]) when you need a number

or

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



mfG
--> stefan <--