You can use myODBC and Access Option "Get External Data"
Siomara Pantarotto wrote:
> Hi all,
>
> I got my java connection working but now I need to export a MS Access
> database to mysql database.
>
> Does anyone knows the fastest way to do it????
>
> My main question is:
>
> Is there a way to export the table structures and data at same time? Or do I
> have to create the tables structures and just export the data.
>
> I noticed some diffreneces in the datatypes when comparing mySQL to Oracle
> and I bet there must be some differences related to MSAccess too.
>
> Thanks
>
> Siomara
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
