yeah there is tis called Access-to-MySQL (http://www.convert-in.com/acc2sql.htm ) ...here's some specs on it
Features All MS Access data types and attributes are supported Works with all versions of Unix and Windows MySQL servers Stores MS Access database into a dump file (see Customize Conversion article for related information) Special approach for VServer users (see VServer User Notes article for related information.) Converts indexes with all necessary attributes Converts password protected MS Access databases Easy-to-use wizard-style interface Full install/uninstall support Requirements Windows 95 or later or Windows NT 3.51 or later At least 32 MB of available memory MS Access 7.0 or higher (ODBC is not required) Necessary privileges to write into database on the target MySQL server Limitations Converts MS Access tables only (forms, queries, reports are not supported) Does not convert system (hidden) tables Does not convert relationships between tables Does not convert databases protected with User-Level security > -----Original Message----- > From: Liam MacKenzie [mailto:[EMAIL PROTECTED]] > Sent: Friday, 20 September 2002 12:07 PM > To: php > Subject: [PHP] Access > MySQL > > > Yeah, I know this doesn't have much to do with PHP... > > does anyone know of a tool that automatically converts an access > database to > MySQL readable data? > > > Thanks a heap! > Liam > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php