MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. Still can't open my Database.
    I get the following message when I try to open my database: The Microsoft Jet Database engine stopped the process because you and another user are attempting to change the same data at the same time. There is no other user. I have not changed anything on my computer or in the database recently. I've tried to find/delete the databasename.LDB file-couldn't find it. Tried to use WhoLockMe program-No response. Can you solve this problem? Thanks for any and all help.
  • 2. Record retrieval question
    I have a lengthy form containing several fields of data. Each record that is entered is given a record identification number. Sometimes the user gets midway into the form and has to stop to display another record. The current unfinished record is saved and retrieved later using the lookup field built into the form. My question: Is it possible to build into the form a "retrieve" button that could pull this unfinished record automatically using the record id number and require no user input? I know the easiest solution is having the user write down the record id number and look it up using the lookup field but sometimes the users forget to write down the record id number which causes them to have to search through hundreds of records which is very time consuming. Thanks.
  • 3. How to Best Record Product Attributes
    Greetings! I am designing an Access '97 database for my company and have run into an issue as to how best to record the various features for the items we sell. For example a refrigerator can have the following options: Type of Refrigerator - Side by Side, Top Freezer, French Door, etc Color - Black, White, Stainless Steel, etc Spillsafe Shelves - Yes/No Icemaker - Yes/No A range might have the following: Fuel Source - Gas/Electric Oven Capacity Color - Black, White, Stainless Steel, etc Double Oven - Yes/No Warming Drawer - Yes/No Number of Elements I have a table (tbl_ModelNumbers) that lists the hundreds of model numbers we sell along with some very general attributes. My question is how do I best go about separating the various options? I really don't want to have two dozen empty fields for every refrigerator (empty options b/c it's not a range, dishwasher, etc). Would I be better off creating a separate table for each product type and use some type of query to combine all of the model numbers into one list? I realize there is probably a simple solution to this but I've been staring at this database for so long that it's probably a matter of not seeing the forest through the trees. Thanks for your help!
  • 4. Full date and day
    On my order form i have delivery date field. I now have a button that creats an email to tell the customer the delivery date. in the VB code i have used me.deliverydate. This puts the correct date on the email but its in the following format 8/9/2006 but i would like it in the following format Friday 8th Septermber 2006. I also have on the email the delivery time using me.deliverytime. But this brings it up as the following format 2:00:00 PM but i would like it as 2:00 PM Can any one help Thanks Simon
  • 5. Query to Select Maximum Age
    Another basic question from newbie. I have a 10 million record database of patient contact with their physician. The original file contained all thier clinical information and personal characteristics. Each patient record was repeated for each visit. I only want a table of unique records for each patient with their characteristics, simple enough with select distinct, but I found that I obtained duplicate records if the patient visited their doctor between birthdays. I have decided to take the record with their max age as more current. The following however did not work, any suggestions? SELECT DISTINCT ptnum, age, sex, address FROM ptdb GROUP BY ptnum, age, sex, address HAVING (max(age));

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