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]