File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes How to automate import in MYSQL ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How to automate import in MYSQL ?" Watch "How to automate import in MYSQL ?" New topic

How to automate import in MYSQL ?

Carla carmona

Joined: Oct 14, 2004
Posts: 14
I there !

I am new to MySQL. I would like to create a script or find a program that would allow me to automate the import of data from a file ( csv, xml or other ) to the relational tables.

Please help !

payal agrawal
Ranch Hand

Joined: Oct 11, 2005
Posts: 44
Look at the URL below:

Import Data from Txt or CSV files into MYSQL database tables

Java program can be automated by using Task Schedular on Windows and similar program on other OS.
I agree. Here's the link:
subject: How to automate import in MYSQL ?
It's not a secret anymore!