MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. format for naming recordset field
    In VB I have a recordset and want to work with specific fields. I realize I can use an index number e.g. rst(23)but I don't like using index numbers in case I change the underlying fields or table later. I also realize you can use a text name of field e.g. rst!"Myfield". But where I am having trouble is when the field has a name such as TblProducts_Location where TblProducts is the table in which the field "Location" resides. How do I use that name as a recordset field? Thank you for the help in advance.
  • 2. Problems Subclassing in Donors/Donations DB
    Hi, I have the sort of standard Donors/Donations DB. The twist I have is that donations can be time, money (which are easy, because they're additive), but then a donor can make an in-kind pledge, of say 3 chairs and a table. Normally, in subclassing the donation, I would end up with something like this: standard donor DB of just money/time: Donor--1,M--Pledge--1,M--Payments (Modeled after Rebecca Riordan's article on Access Web) donor db with subclassing Donor--1,M--Pledge--1,1---(disjoin/subclass)--PledgeType---(1,M)--PledgeDetails---(M,1)---Payments Main Form: Donor Subform: Pledge SubSubform: PledgeType (combobox for Pledge Type and then contains SubSub? Or just unbind? SubSubForm: PledgeDetails (what was pledged) Summarizing donated time/money isn't that hard. But I need to be able to record and keep track of in-kind promises that may or may not have been delivered. What's the easiest/most effective way to do this so that can come up with a summary along the lines of: 500 total hours donated. $20000 donated. and then there's the stuff I can't really easily summarize... 3 stoves, 4 chairs, 2 tables. Any idea how to tackle this problem? Thanks, Pieter
  • 3. A97 - How to preserve eMail addresses pasting contact info from MS Word doc to A97?
    I have a several hundred contact info entries in an MS Word document (name / addr / phone / email / website) - the usual sort of thing. I want to put the data into an A97 table. In my Word document, a URL typed in shows up as a hyperlink. Cutting & pasting preserves the URL because they're typed in literally. On the other hand, the eMail addrs show up as the person's name (John Doe) and an eMail type hyperlink is in place behind the scenes so-to-speak. But cutting and pasting the eMail token preserves the token only - IE, "John Doe" instead of XXXX@XXXXX.COM . So, I'm at a loss as to how to get it into Access w/o manually extracting each and every one of the addresses - whew! Any suggestions?
  • 4. How to handle with "&" in text
    Dear reader, If have the following two results in the same text. In case the content of the field ItemText = Input & Mutations The following VBA code: Me.Caption = Nz(Me![ItemText], "") Displays the content as: Input & Mutation And the following code: Me("OptionLabel" & rst![ItemNumber].Caption = rst![ItemText] Displays the content as: Input _Mutations ___________________________________ In case the content of the field ItemText = Input && Mutations The first code displays: Input && Mutations While the second code displays: Input & Mutations Is there any solution how to handle with "&" in text fields. Tanks for any help. Kind regards, Simon van Beek

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