Uploading Access files to MySQL (Training From The Source)

Forum|Forum|19 years ago
February 22, 2007
4 replies
332 views

I'm reading Dreamweaver 8 Training from the Source, and am having trouble uploading the Access file to my website (hosted on GoDaddy). I can connect to the mysql database on my site, throught dreamweaver, but the database is empty. Meanwhile, the book says the database should be filled up with the Access file. I can see the Access file on my computer and know where it is but don;t know how to get it up on my website, and running thru dreamweaver... help???

Server side applications

This topic has been closed for replies.

Bob_Flynn__IN_Univ_

Participating Frequently

In the lesson07\Start folder there is a file called newland_tours.sql. That contains the SQL to build and populate your MySQL database. Does goDaddy provide you with a graphical interface for your database like phpMyAdmin? If so, that has a import tool. You can use it to browse to the newland_tours.sql file and it will take care of the rest.

C

Creativ_Technologies

Inspiring

You can't do this with DW. You can do it a few ways, though.

Access can export its tables to a variety of formats, including ODBC. This allows you to export an Access table to MySQL by way of the Connector/ODBC ODBC driver provided by MySQL AB.

Another way to import data is to export the data from MSSQL/Access in a text format and import it directly into MySQL. When exporting, common formats such as tab-delimited or comma-delimited will work fine for later import into MySQL.

Or you could purchase a tool that can do it for you. There may be free ones if you do some snooping around.

N

nwatkin03Author

Participant

yes i need to upload an .mdb file to mysql through dreamweaver.

C

Creativ_Technologies

Inspiring

Do you mean a .mdb file? An access database file? Your trying to upload a .mdb into MySQL?