Export access data to remote mysql database?07.12.13

1. make your mysql remotely accessible by comment out the bind config in mysql server and create a user with all privileges like: GRANT ALL PRIVILEGES ON *.* TO 'foouser'@'%' IDENTIFIED BY 'mypassword' restart the mysql server 2. download and install mysql odbc for windows http://dev.mysql.com/downloads/connector/odbc/5.1.html 2. a. after installation open access, select your table and right mouse click export>odbc_database b. write in the table name c. click new, select the odbc mysql driver and test and create a data source object 07.12.13

http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024