MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. Cant open database (may not be an access issue)
    When I try to open a database that on one of my network mapped drives I get the following error=3F "This file is located outside you intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems" I have to copy the database to a local hard drive, open it, make structure changes, and copy it back to the network drive. I CAN link to the database as it resides on the network drive. All sharing is set up. What the heck do I need to do to be able to open the database directly when it is residing on the network drive?
  • 2. importing specific records
    Hi, In order to keep the file that's in development up to date with the reference (and still used) file, I need to regularly import the original main table and then physically select and append the imported records into the table I am working on. Is it possible to import specific records from the main table? At the end of each day, I'd like to import and append the new records from the current table in the one I am working on. Is this possible? Regards, Stinky Pete ;-)
  • 3. Selectively deleting records
    I am researching the use of physician services that are recorded in a billing database of over 10 million records. I am only interested in the patient's treatment type, and their attributes (age and sex). Simple enough, but the DB is used to record journal entries and adjustments. If a patient gets recoded, then that is entered as a separate record with a negative unit. Typically there are three records: patient# treatment# units 123 200 1 123 200 -1 123 201 1 This is really only one correct visit for treatment 201. If I just delete units <0, then I get an incorrect unit for 200, and one correct unit for 201. Need to mark and delete the first to entries. I can do it by creating a table totals for negative units by treatment and subtract from the totals for each treatment total, but I then I have all these records that have to be excluded for unit level analysis. Would rather just mark the two records and delete. There can be many records for one individual for different codes, so it gets complicated pretty fast. thanks, really need to get this done
  • 4. Sub-SubForm Reference Problem
    I've got a form (frmDeal) that has a subform (frmDeal_Tranche) that has a subform (frmDeal_TrancheCusip). When I try to refer to properties on the "Cusip" form at the end of the chain, MS Access is throwing "2455: Expression has invalid reference to Property Form/Report" In an Immediate window: ------------------------------------------ ?me.Name frmDeal ?me.subTranche.Form.Name frmDeal_Tranche ?me.subTranche.Form! subCusips ?me.subTranche.Form!subCusips.SourceObject frmDeal_TrancheCusip ?me.subTranche.Form! ("2455: Expression has invalid reference to Property Form/Report") ------------------------------------------ Am I trying to push MS Access to far? Or am I just doing something simple-and-dumb? -- PeteCresswell

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