MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. What is the Best Way to Copy a Recordset?
    I have a table in MS Access 2003 that contains records that I would like to copy to the end of the table. There is one slight deviation from just doing a straightforwared COPY, however, in that I want to append the new records using different value of column 1. Here's an example of what I'm talking about: Values in in Table1 before "copy" operation: Bill, 3200 Palm Blvd Bill, 1425 North Drive Sally, 234 Washington Drive Sally, 13475 Harding Street Tom, 2433 Folk Street Now I want to take all of Bill's records and copy them over to Hank so that I end up with: Bill, 3200 Palm Blvd Bill, 1425 North Drive Sally, 234 Washington Drive Sally, 13475 Harding Street Tom, 2433 Folk Street Hank, 3200 Palm Blvd Hank, 1425 North Drive (The value "Hank" is provided via a local variable) What's the best way to do this? I would really like to execute an SQL INSERT/SELECT statement because it seems like it would be easy, but I'm not sure how to incorporate the "Hank" value into the SQL statement.
  • 2. Problem while opeing the Access DB
    I have a access Database created in NT (office 97), but my clients have migrated to W2k (office 2K) so when they try to open the Access MDB which was created in throws the below given error.... The current user account doesn't have permission to convert or enable this database. To convert or enable a database, ensure the following: * You must join the workgroup that defines the user accounts used to access the database. * Your user account must have Open/Run and Open Exclusive permissions for the database object. * Your user account must have Modify Design or Administer permissions for all the tables in the database, or it must be the owner of all tables in the database. * Your user account must have Read Design permission for all objects in the database. * Request that other users close the database. How do i over come this..plz help me i am running short of ideas to resolve this problem.. Appreciate u'r effort in helping me out.... Thanks in advance if needed you can also send me your suggestins to my id XXXX@XXXXX.COM ...
  • 3. ADO Recordsets and Forms
    Is is possible to create an ADO recordset and then base a form on it somehow using the RowSource property of the form?
  • 4. HELP!Unable to run macros in ms access database FROM VB
    Iam unable to run a macro from visual basic... The code does not work when the ms access database(any database ) is open... HELP! Dim strDbName As String Dim strlvsendkeys As String Dim Objaccess As Object strDbName = glopath If User_FAS <> "" Then strlvsendkeys = "+{TAB}{DELETE}" & User_FAS & "{TAB}" If Pwd_FAS <> "" Then strlvsendkeys = strlvsendkeys & Pwd_FAS End If strlvsendkeys = strlvsendkeys & "~" End If DoEvents SendKeys (strlvsendkeys) Set Objaccess = GetObject(strDbName, "Access.Application") Objaccess.DoCmd.RunMacro "mcrValidateArchiveClaims" Objaccess.DoCmd.RunMacro "mcrCheckModulesArchive" Objaccess.DoCmd.RunMacro "mcrCheckCentreArchive" Objaccess.DoCmd.RunMacro "mcrCheckMInfoArchive" Set Objaccess = Nothing Regards, Arch

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