MySQL, microsoft access and website?

Im just wondering what the MySQL code is for putting a database made on microsoft access on a website (dreamweaver). and also, where do you put the code?

MySQL, microsoft access and website?hp

I'd have to take a look at Access, it's been a while (and it depends on your version). But in a nutshell..

1) You'll need to export your Access data, into a CSV file, an XML file, or a series of SQL statements

2) If your MySQL is on a host with phpMyAdmin, you can import any of the above into your MySQL database.

3) If you have direct access to the MySQL server's IP address, you can use an administrative tool like those available from MySQL's site, or SQLYog, to import the data for you (they are also more convenient than phpMyAdmin if we're talking about a LARGE upload of data, because of PHP's inherent limitations and restrictions (especially if you're on a shared hosting plan).

MySQL, microsoft access and website?mcaffee

MySQL and Access are two different database management systems. To use MySQL you must convert your Access Database. Fortunately MySQL has provided a tool to do just that it is called MySQL Migration Assistant. There maybe some problems with the queries because Access uses Visual basic functions in thier queries. As to where you put the code to use in a web site depends on several factors. First the type of server. This will determine the server languages available to you. With IIS you can use most server side languages, this is also true of Apache but the Micorsoft languges are not as fully supported if at all. The next issue is the language Perl, Ruby, PHP, VB or C#. You may also choose a framework Rails, ASP.net, Cake. The frameworks are language dependent. Rails goes with Ruby, ASP.net goes with C# and Visual BASIC, Cake goes with PHP there are others . So the code goes on the server where specified by the rules of the language and or framework you have chosen.

Dreamweaver Supports PHP, C#, VBS, VB, and Coldfusion sever side languages.
u can add the code to your database using PHPMyadmin in your control panel of website.