Link to home
Start Free TrialLog in
Avatar of InNoCenT_Ch1ld
InNoCenT_Ch1ld

asked on

creating csv file

hi, how do I read data from MS Access and then create and 'print' all the data into a csv file?
do i need any special library for this?
ASKER CERTIFIED SOLUTION
Avatar of Mayank S
Mayank S
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you want to know how to read tables from Access, use the JDBC tutorial:

http://java.sun.com/docs/books/tutorial/jdbc/

Samples - http://www.javaalmanac.com/egs/java.sql/pkg.html


SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of InNoCenT_Ch1ld
InNoCenT_Ch1ld

ASKER

Hi all, tks for responding..
I have to apologize to all of you for not making things clear... ;p

first, I know how to read data from Access... and I know that we can export the data into CSV files...

but the problem I am facing now is, I got a program, that will search through a directory for .DBF files and transfer all those data into a single Access file. (each.DBF file will be 'converted' into a single table).
after this, the program also needs to extract those data in the access table into a CSV file (one table one csv).

what I done now is, the program scan dir, read dbf and copy to Access's table... except the CSV part...
I need to automate the extract CSV part because it will be like 1500++ MS Access files and each file contains about 15-20 tables... so to do it manually, it is very painful and time consuming...

so, do i just 'extract' the csv through FileWriter like what berhurley suggested? Btw, I seriously don't know how to use the Input/Output stream things... so any code will be appreciated ;-)
ONE more thing, the carriage return must be at the end of last line... EG:

1,2,3,4
1,2,3,5
1,2,3,6 *