All geek questions in one place

Export mysql database to Microsoft Access (.mdb)

I am looking for some tips on how to export the mysql database to a .mdb file that can be read in Microsoft Access 2007+ (and is being edited too!). This should be a script that can run on a Linux server (possibly using PHP?).

I can't seem to find anything. Any ideas?

Hooray!

+3
source share
4 answers

Thanks for your advice :)

Since then I found out that we already use this product elsewhere: http://dbconvert.com/convert-access-to-mysql-pro.php?DB=1 It works under Wine on our server, although I don’t I think that it supports the latest versions of Access.

+2
  • ODBC MySQL.
  • DSN ODBC.
  • Access :

SELECT * INTO AccessTable     FROM [ODBC; DATABASE = Database_Name; DSN = DSN_Name; OPTION = 2059; PWD = MySQL_Password; PORT = 0; UID = MySQL_User].MySQLTable

( : AccessTable, MySQLTable, Database_Name, DSN_Name, MySQL_Password, MySQL_User)

+2

CSV MySql, Access. OLEDB ODBC .

mdb ? , mysql .

+1

.

The goal of the UNIXODBC project is to develop and promote unixODBC as the ultimate standard for ODBC on non-MS Windows Platforms. This should include GUI support for KDE and GNOME.

- http://www.unixodbc.org/

0
source

Source: https://habr.com/ru/post/1754652/

More articles:


All Articles