473,414 Members | 1,848 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,414 software developers and data experts.

Exporting to text file.

489 256MB
This is driving me nuts!!! I have a table that one of the columns is set as Double, Fixed, 3 digits. I try and export this to a .txt file for a backup using the docmd.transfertext command but when I look at the file I only have 2 digits. What am I doing wrong and how can I get this to export 3 digits.
Hopefully come one can give me an answer.
Thanks for all your help.
Feb 16 '10 #1

✓ answered by ADezii

  1. Create a Query based on your Table.
  2. Create a Calculated Field which Formats the [Double] Field to display 3 digits, something similar to:
    Expand|Select|Wrap|Line Numbers
    1. NewDouble: Format([Double],"#,#,#.000")
  3. Do not Show the original [Double] Field in the Output.
  4. Show the Formatted Field ([NewDouble]) in the Output.
  5. Used the Query in the TransferTtext Method and not the Table.

4 1599
ADezii
8,834 Expert 8TB
  1. Create a Query based on your Table.
  2. Create a Calculated Field which Formats the [Double] Field to display 3 digits, something similar to:
    Expand|Select|Wrap|Line Numbers
    1. NewDouble: Format([Double],"#,#,#.000")
  3. Do not Show the original [Double] Field in the Output.
  4. Show the Formatted Field ([NewDouble]) in the Output.
  5. Used the Query in the TransferTtext Method and not the Table.
Feb 16 '10 #2
CD Tom
489 256MB
That worked great thanks for the help.
Feb 17 '10 #3
CD Tom
489 256MB
Thanks for the help.
Feb 17 '10 #4
ADezii
8,834 Expert 8TB
You are quite welcome, CD Tom.
Feb 17 '10 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Jayjay | last post by:
Is it possible to export a report to word and have it include the graphics that are in the report? I'd like to take some of our reports and export them to word so we can email those to the...
3
by: Fran Zablocki | last post by:
I have a process that exports an Access table to a comma-delimited text file. One of the fields that is exported shows the date it was exported, using the Date() function. In the Access table, the...
2
by: Kenneth | last post by:
How do I remove the limitation in Access that deny me from exporting 24000 rows and 17 columns (in a query) into Excel? Kenneth
1
by: nunYa | last post by:
I am trying to use the DoCmd.TransferText method to export an access table to a Tab Delimited Text File. I have put the code behind the onclick event of a button and keep getting the error...
4
by: Hitesh | last post by:
Hi, I have three datagrid control on my aspx page and one export to excel button, i want to export all the 3 datagrids contents in one excel file. how can i achive that? -- Thanks Hitesh
6
by: sara | last post by:
I have what I think is a little strange...I have to get data from our payroll system into a specific format (fixed record length) as a .txt or .prn file only to upload to our 401k custodian. I...
16
by: pmatzek | last post by:
I am attempting to automate a process involving importing a .txt file into an existing table, changing a date in each record, then exporting the table, again as a .txt file. One field contains a...
1
by: Marty Klunk | last post by:
I have an Access97 data base where we are exporting records out to a text file that is then sent to a customer via EDI transmission. The problem I am having is that during the export process access...
2
by: JimmyKoolPantz | last post by:
We purchased som software for encoding a barcode. We want to automate the process of converting a number to a readable barcode. However, I am having a few issues. The file that the barcode...
1
by: ndedhia1 | last post by:
hello, I am creating a comma delimited text file in php and need to export the results to an excel file. I am creating the text file thru querying a mySql database. Right now, we have the .txt...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.