I am using My-Sql
database.
I have MS-Access
as external database .
The MS-Access
database contains the original data's .
I want to do :
Need to retrieve the data's from MS-Access
database , to My-Sql
database table
To achieve this task what i am thinking is :
- Create a java class to retrieve the data's from
MS-Access
- Store the data's into my database
My-Sql
Use
Thread
concept to run the java class for simultaneous process(every 10 mins)I want your suggestion for this, Whether my point is correct? If not , Is there any way to achieve this task simply...!