Change dot to a comma in .txt file

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

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