MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. isolate email addresses
    Hi, I have a very large text file export of email messages from an email client. I've imported into access. It is not segregated in any way except by the message which contains, among everything else, an email address somewhere in the body. IOW, every record looks more or less like this (nonsense text substituted in): posuere dignissim, iaculis eget, turpis. Suspendisse consectetuer neque id odio. Ut ullamcorper. Quisque hendrerit XXXX@XXXXX.COM neque eu dui. In lacinia purus in felis. Sed nonummy, nisi pharetra facilisis blandit, lacus urna bibendum diam, If you look close, you'll see in the middle is the email address: XXXX@XXXXX.COM Every record is more or less like this. What I need to do is delete all other text from the records except what qualifies as an email address. So, I guess logically - I need to first find the @ character, then move left and right until I encounter the first space in both directions. Everything in between those spaces would be the email address. Everything else needs to be tossed. Help?
  • 2. Help saving files to disk from within Access using VBA
    I have an Access app which uses Office Automation to manipulate and then save PowerPoint files to disk. It works fine, but I need to update the code and I am having problems with the syntax. Currently, it saves all of the files to one main subdirectory. Now I need it to save the files to separate directories based on the value of a new field in the database. The new field is the name of a person assigned to an account. I have no control over how this value is input and its format is rather inelegant, sometimes it is just first and last name and other times it contains a nickname. So it might be in the form of "John Doe" or it might be "William (Bill) Doe". Anyhow, I need to strip out the last name in this field so I can append it to the path variable. So, my thought was to grab the value of that field, then run a for-next loop starting with the last char and going backwards until a space is found. Then I would use that string as the name of the directory and, if it does not already exist, create it on-the-fly . But I am having trouble with the syntax as it has been more than a year since I did any programming. Does anybody know the syntax for what I am trying to accomplish? Thanks Alan
  • 3. REQ: MS Access Direction to Pursue ...
    Good Afternoon ... ... I hope the sun is shining in your domain ... ... if you would be so kind, would you please suggest MS Access reading material, based on the following input: 1. Knowledge level ... Newbie 2. As a user of MS Access - written programs; i.e., I will be using someone's program; I might have to enter data, look up records, etc. 3. As a creator of MS Access programs Thanks for your time and consideration. Jim Hughes ********************************************

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