MS Access export to text file decimal round off problem

MS ACCESS

    Sponsored Links

    Next

  • 1. linking to an oracal database??
    Hi there, I would like to know where is can find some more information about issues to watchout for when working with oracle databases, where Access xp is the FE and oracle the BE. If I link a table from sqlserver it links as dbo_Categories. How does the table, which at this stage is still in design mode, is called Categories (in oracle), present itself, went linked via ODBC to access?? What are some limits? eg: table name length, naming conventions, data types, conversion Issues?? any help is much appreciated. Regards Norman
  • 2. runsql vs Execute
    What's better/ faster/ more efficient. Using Docmd.RunSql or Execute to run sql? When is one better than the other or inappropriate to use? Thanks. jim
  • 3. passing dynamic sql to criteria field
    Could someone please tell me how to pass criteria as if it were a parameter. I have a routine now that creates the sql string (well almost). at present the parameter is [Get DOS module] so I can pass one item ie Module M10S. Want I want to do is send 1 or more parameters ie M10S OR M10SA OR ...... The query works with one parameter can I send the dynamic sql from vba as a complete parameter string once the form calls the query? also I notice the "air" code I have uses the hidden field of the list box ie the PK is being returned can I get the descriptive text ie in my case [Module description (text field)] "M10S" I couldnt see how to get the text string from another column. regards Peter
  • 4. problem calling date function from query
    Hello, I have a question regarding how to format a date in VB so that I can call it from a query and get results. I'm calling functions in the query because that was the only way I found I could set up a query with multiple parameters to return data the way I wanted. (I'm reading up on a filter recordset command that will probably do this much better, but I haven't got it figured out yet.) The query calls all the functions and pulls up data exactly as I want except for the date field. I can't get the query to read the date defined in the function at all. I've simplified the routine so you can see the syntax I've tried. If I can get it to read something simple like this than I can get it to evaluate the date span I want it to. There should be 7 records displayed with the date Jan/02/2004, but these all return empty sets. ATTEMPT 1 CODE: Public Function srcDate3() as String srcDate3 = "#01/02/2004#" End Function QUERY: Field: DateRec Criteria: srcDate3() [I also tried "like srcDate3()] ATTEMPT 2 CODE: Public Function srcDate3() as Date srcDate3 = cdate(01/02/2004) End Function Query: Field: DateRec Criteria: srcDate3() Note: cdate formatted as mm/dd/yyyy Ideally I would like to call a string "Between mm/dd/yyyy And mm/dd/yyyy" where the function determines the mm/dd/yyyy of the span, but I'm not sure I can do that by calling in a function. Thanks in advance, Andy

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:) 

Thanks,
Craig

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.

Hi, 

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. 

-Chris

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
this?

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.

Dave


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