<div>
You should not have to consider this at all.<br />
The decimal separator is controlled by your regional settings. &nbsp;Are you sure you have it set to a comma?<br />
<br />
<br />

</div>


<div>
Yes, I've checked regional settings (decimal symbol is set to comma in &quot;Date, Time, Language, and Regional Options&quot;). Same thing happens if I import the text file to Excel, but here I can simply use &quot;find and replace&quot;. 
</div>


<div>
You're right: The numbers were treated as text. Corrected it by defining fields as numeric and single or double when importing the text file. Problem solved. <br />
<br />
By the way: I was unable to do find &amp;&nbsp;replace &quot;.&quot; with &quot;,&quot; in Access on these records.
</div>


<div>
So you're not quite so much of a rookie as you claim(:-)<br />
That is clearly the best solution.<br />
<br />
I can't imagine why you couldn't use find and replace. But it's irrelevant now.<br />
<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
Using Access 2000, I have imported a text file which uses dot as decimal separator. I wish to change this into comma. I'm a rookie on Access in general and terrible on VBA....
</div>
</div>


Using Access 2000, I have imported a text file which uses dot as decimal separator. I wish to change this into comma. I'm a rookie on Access in general and terrible on VBA....

How to change decimal separator from dot to comma?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.