How to connect Database with MySQL.?

Question

Helo guys. can anyone help me regarding this. i have a DB in MS Acess and i wanted to connect it with MySQL server. can anyone tell me how to do that. as i want to use PHP with MySQL. and i m using WAMP 5. it will be highly appreciated if u help me regarding this matter. Thanx in advance..

Answer 1

I have used Access as a front end to a MySQL database.



For instructions on how to set up and use, follow the link:



http://www.washington.edu/computing/web/publishing/mysql-access-3.5.html



Good luck

Answer 2

I don't know of any way to connect the two databases, but there are ways of accessing the data or transferring the data from MSAccess to MySQL.

You could use the ODBC functions in PHP to connect with the MSAccess database, much like you would with a MySQL database.

Otherwise, it may be easier for you to export each table from MSAccess into a CSV file - you may need to do a spot of light reading on this, but it's not hard; and then import the CSV files into MySQL using the LOAD DATA INFILE or mysqlimport features.



Sorry I can't be of more help. Have a look on the MS Office site about exporting Access tables, and look at the MySQL website about importing them. You could always export the database as an SQL statement, but it's likely that Microsoft Access's SQL language will be slightly different from MySQL's, so this may not be so easy.



Good luck!

Answer 3

You cannot connect to a MS Access Database through a MYSQL Connection.. But you can convert your MS Access Database to a MySQL Database..

Answer 4

use the php to read all the tables in Access and populate the data into mysql or even you may use any utility. you may even do that with open office base

Answer 5

Cant help you at the momment as I have not read up on it yet but you can buy SQL for dummies- the book, it says it is easy