Hi all,<br> i have an access database, and now i want to change it to mySQL. But the question is , how to make the database connection ??<br><br> Also , my idea in this change is, first, using PHP to open both of the access and mySQL connection, then fetch all the rows and columns from access's table and write it on the mySQL's table.<br>Do anyone have a better idea ???
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to make a Database connection with Microsoft Access in PHP ??
- Thread starter 369
- Start date
When you're trying to migrate to MySQl and then not using Access any more, then I would dump all information into a text file from access and load it into MySQL from shell. <br>But when you still looking for a way to send queries into access, then use ODBC.
the way tp connect an Access database is through odbc.
then you can use the obcd functions of php to read the records from the database and write them in the MySQL database.
if you don't know how to declare an access database, just reply this thread, and i'll tell you how to make it.
then you can use the obcd functions of php to read the records from the database and write them in the MySQL database.
if you don't know how to declare an access database, just reply this thread, and i'll tell you how to make it.
- Status
Similar threads
