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?
do i need any special library for this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 *
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 *
http://java.sun.com/docs/books/tutorial/jdbc/
Samples - http://www.javaalmanac.com/egs/java.sql/pkg.html