Access2000 Export to delimited text is truncating decimals

  • Thread starter Thread starter mr
  • Start date Start date
M

mr

I have just run into a weird happening with a table in Access2000. I have
a field that is holding some decimal values. One of the values is 0.4775,
when I export to .xls it retains all the information, when I export to text
delimited access2000 is truncating to 0.47. What am I missing here? is
this a normal feature? Any help would be appreciated. Thanks in advance.
 
If you look through previous discussion threads you will see that this is due to settings on your computer limiting the decimals.

The way to get round this is to create a schema.ini file in the folder you are exporting to and then sql the export to the text file.

Example schema.ini:
[TEST.TXT]
ColNameHeader=True
CharacterSet=1252
Format=CSVDelimited
DecimalSymbol=.
NumberDigits=4

Example SQL:
SELECT a.* INTO [Text;DATABASE=C:\MYDATA].[TEST.TXT]
FROM [MYTABLE] AS a;

*****************************************
* A copy of the whole thread can be found at:
* http://www.accessmonster.com/uwe/Forum.aspx/access-externaldata/6845
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=b56306aaf3de4709891ac2e02845b676
*****************************************
 
Thanks! It worked out awesome.


richard goodwin via AccessMonster.com said:
If you look through previous discussion threads you will see that this is
Click to expand...
due to settings on your computer limiting the decimals.
The way to get round this is to create a schema.ini file in the folder you
Click to expand...
are exporting to and then sql the export to the text file.
Example schema.ini:
[TEST.TXT]
ColNameHeader=True
CharacterSet=1252
Format=CSVDelimited
DecimalSymbol=.
NumberDigits=4

Example SQL:
SELECT a.* INTO [Text;DATABASE=C:\MYDATA].[TEST.TXT]
FROM [MYTABLE] AS a;

*****************************************
* A copy of the whole thread can be found at:
* http://www.accessmonster.com/uwe/Forum.aspx/access-externaldata/6845
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=b56306aaf3de4709891ac2e02845b676
*****************************************
Click to expand...
 
Back
Top