Access and mySQL

[Prince]

I have two questions.
Is mySQL completly different as compared to SQL (in terms of stored format)? [in other words, can SQL file be used in mySQL DB?]

How can I convert Access DB to mySQL? (I don't suppose there is any way to use PHP with Access DB)

 

[Armitage]

Ok, to start, your terminology is a little confusing. When you say an "SQL file" do you mean a the files in which MS Access stores database data, or do you mean an SQL script file?

From the context, I think you mean the former. For reference, SQL is an acronym for a language specification (Structured Query Language). It is not a file format.

In any case ... no, the data file format for Acess is not compatible with MySQL. You can't directly open a database created in Access with MySQL. There are tools to help you make the conversion though. Take a look at the MySQL website. Here's a link.

You might also have a look at the MySQL mailing list archives. The topic comes up fairly regularly.

 

[joinT]

<< There are tools to help you make the conversion though. >>


I found one on tucows Haven't tested it yet though.

Also, FYI - I assume you could connect to an Access DB using PHP, so long as you find the script to open a connection.

 

[Workin']

You can use an Access .mdb file with PHP. Access is ODBC compliant, all you have to do is figure out how to make that work. I don't know how to do that using PHP, but I do know that it can be done without any more difficulty than using MySQL.

 

[riteo]

yo

you can use php to interface an .mdb file. heres all the info you'll need:

PHP: Manual: Unified ODBC functions