Skip to main content
Participant
February 22, 2007
Question

Uploading Access files to MySQL (Training From The Source)

  • 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???
This topic has been closed for replies.

4 replies

Bob_Flynn__IN_Univ_
Participating Frequently
February 23, 2007
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.
Inspiring
February 22, 2007
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.
nwatkin03Author
Participant
February 22, 2007
yes i need to upload an .mdb file to mysql through dreamweaver.
Inspiring
February 22, 2007
Do you mean a .mdb file? An access database file? Your trying to upload a .mdb into MySQL?