can any body help me in importing data from access dtabase to mysql clearly
thanks in advance
<a href="http://www.jobklub.com" target="_blank" rel="nofollow">http://www.jobklub.com</a><br /> 'Add Job To Life'
posted 16 years ago
Hi Now I want to mention that I am assuming you are using mysql on a unix box. I would do it by dumping the Access tables into a comma delimited list, then using a small java app (servlet even) to open the comma delimited file and input the information into the mysql table. (You can use a "Reader" and a "Tokenizer" to accomplish this easily.) A second option is to select all the information from each Access table and create an INSERT statement from it, store this info into a file (INSERTS.txt).. Then all you have to do is issue a "mysql <database_name> << INSERTS.txt" at your prompt. (This way would require come 'intermediate' application quering the database and constructing the INSERT commands). I have used both ways and I found the comman delimited list was the easiest. Almost everything can be exported into a comma delimited list. Make sure that when you create the mysql table you do not enable identity fields or primary keys. Add those later with the ALTER TABLE command. This will allow you to keep referential integrity while tranferring from Access to Mysql as it will allow you to do what's called an 'identity insert'. Hope this helped.
SOURCE CODE should be SURROUNDED by "code" tags.
I will suppress my every urge. But not this shameless plug:
the new thread boost feature brings a LOT of attention to your favorite threads