MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. Open Excel spreadsheet from Access 2000
    Dear All I want to open an excel template from a specific location i.e. C:\MyDocuments\Sheet1 using a button on a form in access 2000. Obviously when the spreadsheet opens it will re-name itself, and i need the users to be able to enter data, that if they want to save it will have to do a save as. I have looked at all the previous posts and tried most of them, but none of them seem to work. I can put a button on that opnes the application no problem, but can see how to get the spreadsheet i want to then open. Can anyone help with this? many thanks Kate Funnell
  • 2. Cannot create Outlook Object?
    I use the following code Dim OlApp As Outlook.Application Set OlApp = GetObject(, "Outlook.application") and if that generates and error (Outlook is not running) I use Set OlApp = CreateObject("Outlook.application") This seems to work most of the time be on some computers I get an error message saying that an Outlook object cannot be created. MSOUTL9.OLB is in the references. This seems to automatically change to MSOUTL10.OLB if a newer version of Outlook is being used. I cannot find why this happens. Can anyone help please. Alex
  • 3. Converting SQL Server Stored Procedures to MS-Access
    Hi, How can I export SQL Server Stored Procedures to MS-Access? Cheers H
  • 4. Setting References
    Why is it that the references I set on my computer, under tools|references, don't carry through to other computers? For example, if I check "Microsoft DAO 3.6 Object Library", why don't those to whom I send the database automatically have the same references checked? Is there some way to do this programmatically? I am tired of having to explain how this is done every time I email a database. Thanks -- Mike
  • 5. Solution for : Access97 SendKeys command disables Numlock....
    Every time I used the Sendkeys command in my application the "Numlock" turned off and I couldn't use the keypad to hit numbers...... The old code was: Private Sub Command1_Click() SendKeys "{DOWN}" SendKeys "^{END}" SendKeys "{TAB}" End Sub So.....I decided to do the following: Private Sub Command1_Click() SendKeys "{DOWN}" SendKeys "^{END}" SendKeys "{TAB}", True 'keystrokes must be processed before control is 'returned to the procedure. SendKeys Chr$(144) 'Turn the "NUmlock" ON again End Sub I know that I have to avoid the Sendkeys statement but if there is no other way.....this solution should help.... George.......

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