Solved

How do I append data from mulitple tables in an access database to a single text file?

Posted on 2006-11-15
4
165 Views
Last Modified: 2010-04-16
I need to write a program to create a single text file from 3 different tables with Access 2002.  Line 1 of the text file is written from the 1st table then multiple lines of text are appended from a second table & lastly, a single line of text is appended from a third table.  I am using DoCmd.TransferText to create 3 different text files & then manually cut & paste into 1 text file.  Any ideas or code would be greatly appreciated.  Thanks.
0
Comment
Question by:gordonrr
4 Comments
 
LVL 5

Accepted Solution

by:
deeppra earned 250 total points
ID: 17954261
Hai,
      you can use JDBC for connecting to the database and it contains all the methods to retrive the data from the database.
give me the structure of your tables.

I think below link contains all the code to connect to a database
http://www.developer.com/db/article.php/3571661
0
 
LVL 4

Assisted Solution

by:hclgroup
hclgroup earned 250 total points
ID: 17955491
Why not create a report (in Access) and then export that report to text file.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
topping2 challenge 13 91
T-SQL:  Sigh---Boy, this is fun.... 12 48
Delphi: barcode reading on android platform 1 30
Query group by data in SQL Server - cursor? 3 34
This article will show, step by step, how to integrate R code into a R Sweave document
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

822 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question