MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. Joining two tables on two fields
    Hello all, I am joining two tables in a query and the output should be all those records where two fields in table1 match two corresponding fields in table2. I joined the tables using both fields in design view and the Select statement in SQL view looks good. The query runs perfectly and shows the result I want but when I save the query and close it, re-opening in design view shows the error message "Microsoft Office Access can't represent the join expression {Table1].[Fieldx] = [Table2].[Fieldx] in design view." This is okay as long as it does not affect the query but when I run it, I am left with a join on only one of the fields and the other join (that of Fieldx) is gone. My trouble is that I am not the only user of this database and someone might accidentally open this in design view and change my query unknowingly. Is there a way I can retain the query as using both fields to join both tables? Any ideas are very welcome. Thanks!
  • 2. Difficulty displaying graph in Form View that I see fine in graph control on form opened in design view
    A97 Am having difficulty displaying graph in Form View that I see fine in graph control on form opened in design view. I know I'm doing something wrong. If I open the form in design view - I see the graph in the graph control. If I dbl-clik the graph control, microsoft graph opens and displays the graph fine there too. But for some reason, it doesn't display in form view. The only thing that does display is the Chart Title (microsoft graph). The only control on the form is the graph control.
  • 3. ODBC connect to remote SQLServer
    what does a user (running XP) need who has Access but no SQLServer, and who would like to connect to a remote SQLServer database via ODBC? This user can set up a new System DSN but he needs a SQLServer driver for this, right? which files does he need to install that? -Michael
  • 4. Populate word Userform from Access
    Hi, I am working with a template document that has previously been created. I want to be able to populate the fields on the Userform on opening the Word template but before the form is shown. I also want to loop through all the controls on the form and get the control name. I have successfully opened the existing template and disabled autonew(). then activated Form1. However, that where I hit a brick wall. I want to avoid coding in word, rather I would like to push the data from access. Can anyone help?

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