MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. 3rd Pary Visual Query Builder?
    Does anyone know of or have a favourite 3rd party Visual Query Builder? We are looking for a very easy to use interface that provides SQL code verification, table joins etc. Thanks, Dave
  • 2. Missing Entries
    Hi, I have a palms table that stores palm census for each and every palm for a block on every trial. Every trial has a set number of blocks and set number of palms. Each of the palms has a palm census done every year to check its status. The problem firstly is that for data entry: Entry is done such that the trial, plot is entered, and also palm number and the status. Sometimes not all the palms are being entered, so there are a few missing palms that have no status in a year and then in the next year it is entered. I would like to do a query that picks up those palms that have not been entered. Firstly there is nowhere in the db that states the total no of palms for each plot - there is only total no of plots for the trial. i have decided to change the data entry form such that the palm number is not entered but should automatically show, so that a palm is not missed. i need help to how to pick up from the current data which palms are missing. Great appreciation for all assistance given, Thanks
  • 3. Fetching record from other table if exist
    Hello, I have 2 tables, one contains log of all incoming phone calls, and the other one is simply a phone book. I want to fetch caller's name if it's already exist in the phone book, and if it doesn't exist yet just fetch caller's phone number. Is it possible to do this in just a single query? Something like: SELECT Switch((SELECT count(a.*) FROM phone_log a, phone_book b WHERE a.phone_number = b.phone_number) <> 0, b.member_name, (SELECT count(a.*) FROM phone_log a, phone_book b WHERE a.phone_number = b.phone_number) = 0, a.phone_number) FROM phone_log a, phone_book b Thanks!
  • 4. How to update form after Listbox is updated???
    "C_Kubie" < XXXX@XXXXX.COM > wrote > I have a populater listbox and I update the contents > by running a different SQL statement via > listbx.Rowsource ="<SQL statement>" > > The contents of the listbox changes but the > form doesn't. That is exactly what I'd expect from the instruction you show. The RowSource of a ListBox determines the contents of the ListBox and nothing else. What change, exactly, do you want in the contents of the Form? The RecordSource of a Form determines the contents of the Form. > What sytax or command should I use to update > the form fields? Without knowing what you have and what you expect, we couldn't be more specific, nor tell you if your expectations are acheivable. Larry Linson Microsoft Access MVP

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