MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. No input updating
    Hi, I have a form (input type) which is based on a table. Let's say it has 2 fields 1: numeric keyfield 2: textfield. When the form opens the numeric is automatically added with 1. When I leave the textfield empty and I close the form, the database is being written. Bu tI don't want that to happen, if the textfield is empty. With which command can I prevent Access from writing to the table when I close the form? Thanks in advance.
  • 2. Outlook Automation and graphics
    Using Outlook Automation, is there a way to insert a graphic in the body of an e-mail so that it appears at the top of an email? lq
  • 3. what is the limit to record size in access
    I have one person who uses an access database for his billing info, and now he is way up there, maybe 20 thousand records.. 1. is there a limit to the size of an access database? 2. this is off topic. this is an access database being used in vb6, is there vb code I could use in vb6 app that will let them compact the database automatically? thanks in advance
  • 4. Increment a number field
    I converted to a DB2 database where the data type was changed from autonumber to number field. I still need to increment the field by one each time a new record is added. Can anyone help me? Thanks
  • 5. Acc97: Code Will Not Compile on Another Machine
    Hi I have an MDE database that stores all 17000000 UK Postcodes. This database also includes a custom function and data type to return map grid coordinates for a given postcode. I have set a reference to this database from another database and I have created a Public Variable using my custom data type. On my PC this works fine and I can compile the code or create an MDE file for the client database. It does not seem to matter if I have the Postcode MDE file on my PC or a server it works fine both ways. If I then try and setup the client application on the users PC's I get a Dr Watson's almost immediately. I have tried compiling the code on a users PC and I get an error on the declaration of my variable that is set to my custom data type. The error message states it is not a VBA project. All PC's have Office 97 SR2 installed. Why does this work on my PC but not others. No other references appear to be missing. Any ideas anybody? Many thanks Tim ffitch

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 61 guest