RE: [PHP-WIN] Acess to mySQL
| From: | Fernando Madruga | Date: | Fri, 16 Mar 2001 15:04:43 +0000 |
| Subject: | RE: [PHP-WIN] Acess to mySQL | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-6101@lists.php.net to get a copy of this message | ||
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:mark@biteit.net]
Sent: sexta-feira, 16 de Março de 2001 14:52
To: php-windows@lists.php.net
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: php-windows-unsubscribe@lists.php.net
For additional commands, e-mail: php-windows-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net