MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. How to get files from the internet
    Does anyone have any recommendations on how to retrieve files from such a site - ie. https? I have been able to retrieve files from a FTP site without any problems. But from a webpage, I'm stumped. I have tried a software package called HTTrack. But all of a sudden it stopped working. TIA Scott
  • 2. sendobject issue
    I would really appreciate help on this issue... We have in our company an information system developed in access 97, and when we try to email a document from it, we get a sendbject command not available. on other machines it does work. now, i've figured out that the long way to fix this is by reinstalling windows, but i want to try and avoid that at all costs, as that's only a last resort. nothing wrong with the code or anything, as i said before it works on other systems. We're running win98 pcs, with sufficient ram. please could somebody help to get a "quick fix". Thanks in advance Yanks
  • 3. First of the Month
    Hi, I have what may be a simple problem, however it is turning out to be seemingly quite hard to accomplish. Well, the people I am asking are ducking for cover anyway. All I want to do, is make any date that is entered, automatically change to the first of the month. Do I need to Format the code, or add an If statement or what? Thanx in advance. Peter ;-)
  • 4. Strange Update Problem
    Hi, I have following problem. In a piece of VBA code in the onclick event of a delete button I delete a specific entry in a table called (TBL_Tasks) via the DoCmd.RunSQL command. Directly after that I start a subroutine. In this subroutine I go check in TBL_Tasks to see how many records I still have, but, unforunately the record seems to be not yet deleted. I placed a Me.Requery between de delete and the start of the subroutine, but it doesn't seem to help. Afterwards, after the subroutine ends, I go chek in the table and the record seems to be deleted. (imagine I have 21 tasks in TBL_Tasks) .... delSQL = "DELETE FROM TBL_Tasks WHERE ID = " & Me!tasknr.value DoCmd.RunSql(delSQL) 'Delete one task out of TBL_Tasks table cnt=CountTasks 'This subroutine just counts the number of rows in the table TBL_Tasks MsgBox(cnt) ' Here I suspect to see 20 in a message box, but I see 21 !?????? ... What is my problem and how can I solve it? Thanks guru's, Wim
  • 5. Code, Macro or Function??
    Hi can someone please give me some kind of rule or preference whether to use a macro a code or a function or query ? I can grasp the basics on the writing of these but when I want to pull relevant data or display a report where the data reaches certain criteria I am never sure which one I should be using and if I am writing it in the correct place? ANY information appreciated Best Regards Neal

MS Access export to text file decimal round off problem

Postby brotherhou » Sun, 26 Oct 2003 07:13:54 GMT

It's found that when exporting a table/query to a text file, numbers
with decimals will be rounded off to 2 decimals (or 0 decimals
sometimes). Is there an explanation or setting for that?

Similar Threads:

1.Exporting Number with Decimals to Text Rounds to 1 decimal place

I have data in Access that I need to export to a text file.  This data has 4 
or more decimal places and when I export the data the text file ends up with 
rounded data to the first decimal place.  Please help:) 


2.Why Access export three decimal but in text file only two decimal

Can any Access 2003 gurus kindly please advice me on the reason why Access 
export table options exports to a text file involving number data type with 
three decimal places but resulting in only two decimal places in my text file 
content ? 
Is it a bug that causes the last decimal digit to be truncated or some 
settings that could help rectify this problem of mine ?

3.Decimal point rounded off when exporting.


I'm running into an issue when exporting a table to a .csv file. The table 
contains columns of numbers many of which contain a decimal point and three 
digits after the decimal. For example 5.123. The problem is that once the 
table has been exported to the .csv file the third number (the thousandth) 
has been rounded and I only get the hundredth (for example 5.12). Have tried 
Access 2002 and 2003 with the same results. The data type of the columns is 
Number, Field Size is Double, with Decimal Places set to Auto. Any 
suggestions? Thanks in advance for your help. 


4.Problems with DBase IV file exporting after converting frojm MS Access 97 to MS Access 2000

In our MS ACCESS 97 database that we have converted to a MS Access 2000
database.  In this application we transfer (TransferDataBase) a table  with
a memo field to DBase IV.  Our application uses the dbf and dbt files
generated to do some further manipulation.  The system works under MS Access
97 but does not under Ms Access 2000.

Is the dbf page size exported different in MS Access 2000?

Any other driver or parameter settings in MS Access that could be affecting

We also notice that the new MS Access transfer cmd produces a new file with
an MDX extension.  Can we get Access to work without this file?

Any help greatly appreciated.


5.Keep decimal places when exporting to text files from Access

6. Export from Access to Text file: Specified number of decimal place

7. import text file errors - cutting off decimals

8. form rounding off decimals

Return to MS ACCESS


Who is online

Users browsing this forum: No registered users and 42 guest