MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. Problem printing a hyperlink document
    I'm trying to use a command button to print a Word document that is in a Hyperlink field. I keep getting Run-Time Error 5273 and it says the document name or path is not valid. The Hyperlink opens fine if I open it manually but not with this code. Any ideas? I'm Access 2002 with WinXP and all the latest updates. I do have Word Objects 10.0 selected under Tools Reference. Thanks, Mike Dim oApp As Object Dim beginning As Single 'Hyper is the text box name that contains the hyperlink Set oApp = CreateObject("Word.Application") oApp.Documents.Open FileName:=Me.hyper.hyperlink.Address oApp.PrintOut FileName:="" 'this will pause the code during 5 seconds, giving some time 'to Word app to send the document to the printer, before quit ' beginning = Timer Do While Timer < begining + 5 DoEvents Loop oApp.ActiveDocument.Close oApp.Quit Set oApp = Nothing
  • 2. Sorting out SQL
    Below is an SQL statement which I have been trying to make work but to no avail. I nned to determine if there is a record in tblReading with this year (2003) and equal to a particular month (TestDate) eg. "March", "June" etc. Can anyone help out please? I keep getting an error with - WHERE (((tblPersonalDetails.[YearLevel])=1) TIA - Ray SELECT DISTINCT [Firstnames] & " " & [Surname] AS Student, tblPersonalDetails.[Surname] FROM tblPersonalDetails LEFT JOIN tblReading ON tblPersonalDetails.[ID] = tblReading.[ID] WHERE (((tblPersonalDetails.[YearLevel])=1) AND NOT EXISTS (SELECT * FROM tblReading WHERE [Year] = DatePart("yyyy",Date()) AND [TestDate] = "March" ORDER BY tblPersonalDetails.[Surname];
  • 3. closing connections and *ldb file after finished
    I've just taken over a website that has an access database and runs on asp screens. For some reason when some people are in the website and accessing things, a lock file *.ldb is created. And when some users try to do something they end up with an error message and then we end up locking us out of the site. The error message received is: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt. I've checked the database and it is not corrupted. I've also worked with tech support from the webhost and they've bumped up our connections to their maximum settings. It appears that someone is logging in and working in the database and causing it to create this lock file and not release it when they are done. How might I go about diagnosing and repairing the problem?
  • 4. can I make a form resizable later?
    If I make a form in Access 2002 without thinking about making it resizable in different browser windows, can I add this feature later? Or do I need to do something about it right at the start, as I'm first designing the form? Obviously I don't know how to do this, either. What's the simplest way? TIA
  • 5. Combine existing forms in one form using TABS
    Can I integrate 3 existing forms (all based on the same query) integrate in one form by using Tab's? Thanx for thinking, Henro

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