MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. Combo/List Box in Query Question/Problem
    I have created form, query and report. In the form I have a Combo Box which pulls the search criteria (SaleStatus) from one of my tables. When I select a status and click on the search button it should run the query and then preview the report. The form is an unbound form with the row source type set to table/query. The row source is a select statement pulling the data from the table. The Name of the combobox is SaleStatus. The search button has the following code attached to the on click event: Private Sub cmdSEARCH_Click() DoCmd.OpenReport "rptPROPERTY", acViewPreview End Sub The query has the following code in the criteria: [forms]![fmPROPERTY]![SaleStatus] Here is what is happening. If I change the box to a text box and manually type in the status and click on the command button, the report is previewed with the correct information being displayed. If I however, use a Combo Box or a List Box, the data in the previewed report is blank. What am I not doing correctly here... Thanks, Ray.
  • 2. Sample Book Database or CSV List
    Hi, I am currently developing an access database for books which contains ISBN,author,title info etc... I am trying to find an online book library or database that would allow me to search for a particular subject and export the results to csv for importing into my database. The list needs to be detailed and contain ISBN, author,year,publisher etc... This is so I can test my database with real records. I've searched universities, bookshops and amazon etc...but none of these seem to have any facilities for exporting your searches to csv or tab-seperated lists. If anyone here can give me some links or offer advice on how i can import real sample data into my book database, you would relieve me alot of cutting and pasting from HTML web search pages. Thanks....
  • 3. Missing Tables - Access 2000
    Hello folks. I have a database with about 10 users. On startup of the front end (Which holds some tables, macros, forms) I am running a macro that deletes a couple tables and imports replacements from the back end, so I can update employee lists at the back end instead of on each users machine. What's happening is about once a week or so (3 times so far this week) my users will try to load their front end and one of those tables is just plain missing, which throws error messages and halts everything since the macro can't find the table to delete. I've got four different databases used for different purposes, but all of them do pretty much the same thing on startup, but it's only an issue on this one. Anybody have any ideas what would cause this, beyond user error (which is certainly a possibility.)?

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