New to MySQL

Hi all,

I work for a small company that runs a dynamic site using PHP, and have recently been put in charge of our database after the sites and database were designed by an external company.

I've got HTML/Javascript experience but am new to server side development.

Basically, we run off of one database with multiple tables within it.

I have set up MySQL Front and installed the ODBC driver. I can connect to the database via My SQL Front and view and create tables.

I have been given various excel documents with the field data for the new tables and need to import them into new tables within our one database.

In MySQL Front, I have managed to create a new table, for example ...called 'Furniture', It has the correct field names, but it is empty.

My question is....how do I import data from these excel spreadsheets onto the new table I have created? Do I need the database as a physical file on my computer to do this?

I understand that I need to use access, but how do I set it up to link data from there into MySQL Front?

This is probably pretty straight forward, but I am really stumped until someone shows me the light!!

Thanks in advance,

Rob

Hi,

You are right about going to Access. First convert your Excel data into Access tables.

Go to File -> Get External data -> Import, option on the Access 2000 menu bar. From here you can easily import your Excel files to Access tables.

Now, there's this Free program called "Access-to-MySQL" to convert Access data into MySQL tables for you automatically. Go to this web link:

http://mysql.netvisao.pt/portal/software/item-98.html

You can download it and try. There are various such converters avilable on the net. Just search it with "google" or your favourite search engins for keywords like "access to mysql".

John

I don't know how MySQL Front handles it, but mysql does allow you to import delimited data as well, so you may not need to go to Access. Usually it's just a matter of defining the field order, the delimiter, and the line-ender. I would think mysqlfront would have this utility built in. If not and if you have continued trouble, try phpmyadmin.