MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. lookup problem
    I am having a problem with how to get a lookup to work how i want. What i want is the user to be able to use the lookup on a form to select the supplier for that product however there is different classes of supplier and i only want them to see the relevent class on that form? All suppliers are held in one table with their own ID Name and Class The job table is the other table where one record will contain multiple items all of which could be a different supplier and will store the supplier ID. Its simple using the lookup wizard to creata a lookup to do this but how do i limit it on the supplier class? Any help greatfully recieved Glyn
  • 2. Redefine field data type
    Hi, I am trying to write a function in a module in MS Access 2000 that will change the data type of a field called 'Start' in table 'bo_cpm_CS01ALL'. Here is the code that I have done so far but when I run it nothing errors or changes to the table. The code finds the table and field, creates a new field called 'temp' then copys 'Start' to 'temp' then deletes 'Start' and renames 'temp'. The field 'Start' has data type dbDouble. Any help would be great!! Public Function ChangeFieldType() 'Purpose: Changes a field's datatype Dim db As DAO.Database Dim tdef As DAO.TableDef 'Table to modify Dim fldOld As DAO.Field 'Field to modify Dim fldNew As DAO.Field 'Destination field Dim Property As DAO.Property 'Field property Dim strSQL As String 'SQL string to move the data Set db = CurrentDb 'Get the table definition Set tdef = db.TableDefs("bo_cpm_CS01ALL") 'Get the original field Set fldOld = tdef.Fields("Start") 'Create the new field Set fldNew = tdef.CreateField("temp", dbDate) 'Append the field tdef.Fields.Append fldNew 'Copy the data strSQL = "UPDATE bo_cpm_CS01ALL Set bo_cpm_CS01ALL.Start = temp" db.Execute strSQL, dbFailOnError 'Delete the original field tdef.Fields.Delete "Start" 'Rename the new field fldNew.Name = "Start" End Function
  • 3. Formatting subreport "report" headings
    I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user inputs the program desired then only those students in that program are printed. I want the subreports headings to print only for the first student on the page. Is there a way to suppress printing of the headings on subsequent students on that page? I tried the following in both the subreports' ReportHeader_Format and _Print events: lngCount = lngCount + 1 If lngCount > 1 Then Me.ReportHeader.Visible = False End If Thanks for any help or advice.
  • 4. Access ducumentation program
    Back when I worked with Access 97 I used a developer's tool kit that documented my programs and did analysis of my databases, queries, forms and reports. I'm now using Access 2003 and would like to find a product that will document my programs. I was hoping something would have been built in by now but don't seem to see anything, Any suggestions of a reliable product that may be available?
  • 5. Access 2000 - Query HELP!: Why does it not sum credits/negative dollar amounts?
    Group By - Client Sum - PastDue: Iif(DateDiff("d",[InvoiceDate],Date())>30,[InvoiceNetTotal],0) Sum - Current: Iif(DateDiff("d",[InvoiceDate],Date())<31,[InvoiceNetTotal],0) These 2 sum fields work fine, EXCEPT it is not summing my negative numbers/credits. Can not understand why?

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