MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. Use VBA to insert a new record in a subform?
    How do I use VBA to insert a *new* record into a subform? I have a master form with client information, and a sub form with billing information. I want to click on a button ("Add Data") and have a record inserted into the subform's table, with date created and some information from the main table inserted into the proper fields in the subform. After the record is inserted, the data entry operator enters a Date Of Service and a billing code. I've created code to copy the the information I need from the main table and place it in the proper fields, but it always goes to the first record in the subform and overwrites the existing data. I have to manually enter the subform and move to a new record, then click on the "Add Data" button, it then inserts the data on the new record line. Thanks, Scott
  • 2. Output Report to Word
    Yes I know it can't be done in an editable form - well maybe not. Assuming I have a report textbox with CanShrink and CanGrow set to yes, is ther any way of calculating the length the textbox will grow to in order to accomodate the text. If so is this done OnFormat or OnPrint Thanks Phil
  • 3. Expanding memo field to larger form
    I have an Access adp linked to an SQL db that's tracking tasks. On the primary data entry form, there's a fair whack of info, so the memo field for entering details about the task to be completed is relatively small. I was trying to place a button on the form that, when clicked, would open another form with just the contents of the current task details in it. I used the button wizard in forms design to create it, as it seemed to do what I wanted it to, but I'm getting an error. Here is the code the wizard created for the button: Private Sub cmdExpandDetails_Click() On Error GoTo Err_cmdExpandDetails_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmTaskDetailsExpanded" stLinkCriteria = "[TaskDetails]=" & Me![TaskDetails] DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_cmdExpandDetails_Click: Exit Sub Err_cmdExpandDetails_Click: MsgBox Err.Description Resume Exit_cmdExpandDetails_Click End Sub Here is the error I get when I click the button: There was a problem accessing a property or method of the OLE object. I've tried doing a newsgroup google on this, but none of the threads I'm turning up seem to have a fix detailed, though I could be missing something. Anyway, thanks for any help you can give me. :) -- Siobhan Perricone Systems Developer Vermont Agency of Natural Resources (my comments are my own, not my employers)
  • 4. Is it possible to highlight portion of text in Msgbox?
    I would like to highlight (say make it bold) a couple of words in a Msgbox. Is it possible? Similarly, how can I change the caption of a label with highlighted text?

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