how do i port
- Mysql to Access
- Access to Mysql
- Mysql to Mysql
Porting MySql <-> Access
1 & 2, no clue.
3. Use mysqldump
Johan
[deleted]
1 & 2 search the forum, and read the columns
3 porting from mysql to mysql? uhm... are you feeling allright?
a year later
Maybe you try this tool: http://www.convert-in.com/acc2sql.htm
2 years later
Originally posted by Anon
how do i port
Mysql to Access
Access to Mysql
Mysql to Mysql [/B]
2. You must first install mysql odbc drivers on a MS platform that has MS Access. There is a good article on this procedure at www.nusphere.com/products/library/devshed_mysql_odbc.htm
In access open the access database you wish to export and then click file and export in the file type field select odbc and you database. and this will build the access file in mysql. One other concideration you must have a user defined on the mysql server that has rights to write to mysql, from the MS computer that you are working on. The database must exist on mysql so that you can configure ODBC.
1. Once you have connected to the mysql database that you wish to import to access using the odbc driver as above you open MS Access create a new database and use the import feature in the same way that you used export in the paragraph above.
a soft name":mysql2access
i can send it;if you need;