Access query data export

Warren Thai

I am using Access 2003. I need to export data from a query to a .txt file. I
know how to do this but however there is a problem with my data being
rounded. The numbers in the data have 3 decimal places but when I export the
data, the numbers in the text file are rounded to 2 decimal places. How do I
stop this rounding?
Warren

Jun 27 '08 #1

Subscribe Post Reply

2096

KC-Mass

I think you need to look at the data table these numbers are coming from. I
assume that the fields containing the data are defined either as Numbers
(Double) or Currency. The decimals have to be specifically set to 3 if you
want that on export.
If the decimals are set as "AUTO", the export will have two decimal places
even though your data had three. If the decimals are set as "3" they will
have three places.

Regards

Kevin

"Warren Thai" <wt****@optusnet.com.auwrote in message
news:48***********************@news.optusnet.com.a u...

>I am using Access 2003. I need to export data from a query to a .txt file.
I know how to do this but however there is a problem with my data being
rounded. The numbers in the data have 3 decimal places but when I export
the data, the numbers in the text file are rounded to 2 decimal places. How
do I stop this rounding?
Warren

Jun 27 '08 #2

by: Mike MacSween | last post by:

My client has an MS Access database application on her local machine. I have full access to that in terms of changing the design. I've got a simple PHP/MySql application on shared hosting, so no...

PHP

Access Reports using ASP

by: Joris Kempen | last post by:

Hi people, I know that the question has come around sometimes: How to open an Access Report using ASP and export it to for example RTF. I'm trying to implement the first method of David...

ASP / Active Server Pages

2 Access XP/2002 Issues

by: Julia Baresch | last post by:

Hi everyone, My company recently upgraded from Office 97 to Office XP. As those who've read my other posts know I have a database with 3 nested subforms Main form-->First Subform-->Second...

Microsoft Access / VBA

Access Scalability - records vs. filesize

by: deko | last post by:

Do I get more scalability if I split my database? The way I calculate things now, I'll be lucky to get 100,000 records in my Access 2003 mdb. Here some math: Max mdb/mde size = 2000 x 1024 =...

Microsoft Access / VBA

trying to copy an Access 2003 pivot table to excel or word .... or something

by: Jerome Ranch | last post by:

Okay So I've got pivot tables setup in Access 2003. Only about 30K records in the current 2005 databases...the pivots summarize the info in a number of nice ways. I need to get the pivot tables...

Microsoft Access / VBA

Access 2002 vs. 2003

by: Neil | last post by:

We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...

Microsoft Access / VBA

Access Tables to Excel Worksheet Export

by: smaczylo | last post by:

Hello, I've recently been asked to work with Microsoft Access, and while I feel quite comfortable with Excel, I'm at a complete loss with databases. If someone could help me with this issue I'm...

Microsoft Access / VBA

Export Access query to Excel using a command button on an Access form

by: CoolFactor | last post by:

MY CODE IS NEAR THE BOTTOM I want to export this Access query into Excel using a command button on an Access form in the following way I describe below. Below you will find the simple query I am...

Microsoft Access / VBA

Export MS Access Query to CSV File

by: chadh | last post by:

Hello, I'm having some troubles exporting a query to a csv file. I am able to use the doCMD.TransferText to output the query to the csv file, however, I cannot get it to use the Export...

Microsoft Access / VBA

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Similar topics