Short Answer: YES.

Long Answer: look on the tools page on www.mysql.com/; there you will
find at least two different ways (not to mention ODBC drivers for
MySQL that would allow you to copy data using Access):

  My Access 1.4
    MyAccess is an AddIn for Access 97 / Access 2000 to manage MySQL
    Databases from within MS Access. MyAccess has an Access-like
    database window and allows you to create, modify and view
    MySQL-tables without any knowledge of SQL.

  ExportSQL:
    ' GOAL
    ' Export all tables in a MS-Access database file to 2 text files:
    ' one containing SQL instructions to delete the new tables to be
    ' created, and the other with SQL instructions to create and
    ' insert data into the new tables. The table structure and data
    ' will resemble as much as possible the current Access database.

HTH,
  Madruga

-----Original Message-----
From: Mark Collins [mailto:[EMAIL PROTECTED]]
Sent: sexta-feira, 16 de Março de 2001 14:52
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Acess to mySQL


Is it possible to export the content of an access database to mySQL? Most of
my clients have Access as standard. Could be a dumb question, appologies if
it is. Pretty new to the database thing.



-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to