SELECT * INTO mysql_table IN ""
[ODBC;DSN=mysql_dsn;SERVER=localhost;UID=root;PWD=]
FROM access_table

You need myODBC and execute this in Access. Respect the double empty quotes.

----- Original Message -----
From: "Oladejo, Tokunboh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 1:48 PM
Subject: Access to MySQL


> Hi All,
>
> Does anyone knows of any easy way/short cut of exporting Microsoft access
> tables into MySql database.
>
> Thanx
> All
>
> ---------------------------------------------------------------------
> 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

Reply via email to