MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. Presenting queries results
    I have a about 15 different numbers (which are the result of 15 query calculations (queries on different tables)) which I want to present in a report. What would be the easiest way to get those values from the query into one report? I don't seem to be able to base a report on more than one query. I'm rather new to Access and I have no VB experience so I hope it can be done without it. Thanks, john
  • 2. How to Combine Data from multiple tables or sources?
    I am at a complete loss on how to do this. I am using Microsoft Access 2000, to implement a preliminary version of a reasonably modest relational database. I have two Access Tables (imported from MS Excel spreadsheets), and I need to somehow get the data for a "Person_ID" brought over from one to the other. In Table_A, there are many records for each person, and the first and last name are included, but the Person_ID field is empty. There are more than 65,000 records. In Table_B, there is only one entry for each person, and each record contains a field called Person_ID. There are more than 15,000 records. I cannot figure out any way to bring the Person_ID data from Table_B to Table_A, to allow me to create a relationship through the Person_ID field to several other tables. Can someone point me to a resource that would tell me how to do this? If the data sources were smaller, I could export them to Excel and manipulate them there, and then re-import tham, but there are more than 65,000 records.
  • 3. How to copy form: Access 2003 to Access 97
    Hi all, I have converted a database from Access 2003 to Access 97. Everything gets neatly imported into the new database except for one form which continues to show a fatal error when I try to open it in the new 97 database: "Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. If you were in the middle of something, the information you were working on might be lost. For more information about this error, click here ___." This is a form that I am using as a sub-form on a parent form. The parent form is imported okay but no matter how many times and in how many different ways I try to get this sub-form into Access 97, it just won't work. Does anyone out there have any ideas on how I can get it into an Access 97 database without error so that I do not have to re-create it? Or why is this happening. Thank you. Carmela
  • 4. to show a recordset as table
    use this vba code after to connect Access to a remote db. I obtain a recorset and I want to show it as "table". I bind this recordset to a form, but how to show as table? This is the code (associated to a clik of a command botton): Set recSet = New ADODB.Recordset With recSet Set .ActiveConnection = con 'con is the connection defined above in the code .Source = "select var1 from datamart where rix=4" .LockType = adLockBatchOptimistic .CursorType = adOpenKeyset .CursorLocation = adUseClient .Open End With Set Me.Recordset = recSet After this code I correctly bind the recordset to the form , and if I set the Form to "spreadsheet", I obtain a table with the just number of records but without fields...... Someone could hel me? thanks michele de meo

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