> Does anybody know about free tools which will move Access-to-MySQL and which
> will not spoil or change the data structure.
>
Not supported any more, but mySQLFront has been my flavour of mySQL gui
forever and has been relaunched!!!!! (I only just this second found
this out!)
http://www.mysql-front.de/ - there's a beta version 3 there (Only just
found it so don't ask if its any good. ;o) )
Anyway in my excitement I've got off the track! Version 2.5 of
mySQLFront has the ability to import Access databases (use the ODBC
import and then select the Access mdb file or even the ODBC DSN) and
away you go.
You'll need to check through your datatypes for any column (particularly
numbers) as Access doesn't have a limit for integers and mySQL defaults
them to something like 11 digits, which is a bit excessive!
Hope that helps
Regards
Stephen
PS. Just installed Version 3. The import option appears to be disabled
at the moment. It is after all only a beta.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
