List:General Discussion« Previous MessageNext Message »
From:Mauricio Sthandier R. Date:August 16 2002 7:16pm
Subject:Re: Access to MySQL
View as plain text  
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" <to@stripped>
To: <mysql@stripped>
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 <mysql-thread117379@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-php_dev=ingesoft.net@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
Access to MySQLTokunboh Oladejo16 Aug
  • Re: Access to MySQLMauricio Sthandier R.16 Aug
  • Re: Access to MySQLDonna Robinson17 Aug
  • RE: Access to MySQLAron Pilhofer17 Aug
RE: Access to MySQLMark Schoonover17 Aug