convert access database to mysql
-
is there some way to convert a access database to a mysql ? I am not interested in expensive tools , as i can not pay for this .
The only technical thing I know about Access is that it never should have been written. Even MSDE is better than Access! To be safe, I'd export the Access database as a CSV file, manually create your schema inside MySql, and then tell MySql to import the CSV file. It's a little more work then a fancy point & click tool, but you know your data will go through perfectly. -Thomas
-
is there some way to convert a access database to a mysql ? I am not interested in expensive tools , as i can not pay for this .
Hi, Take a look at this: http://solutions.mysql.com/software/?item=98[^]. It's from the MySQL website. Although the tool is shareware, you might be able to convert with the demo version. I haven't looked so I'm not sure if they disable it in the demo version. In any case, there are tools, so if that doesn't work, you can look elsewhere on the MySQL website or on Google. Sincerely, Alexander Wiseman Est melior esse quam videri It is better to be than to seem