SQL Excel

Hello Friends,

I am a web developer currently in the process of building an online contact directory for a medium scale client. This directory will end up being the place to go for all employees and customers looking to contact anyone employed with the company. I intend to use PHP script to load the data on a web page. I will also make use of several other web languages [HTML, CSS, JavaScript] to employ a nice web interface.

My Problem:
I currently have an excel workbook consisting of 1500 lines of employee information on my local computer. And a PHP/MySQL enabled server which I can access via remote desktop. It became apparent very early that one of two things would have to happen.

(1) I re-type all of that data by hand into a HTML/PHP form to have the information input into the remote server.

-or-

(2) I find an alternative software or add in which will do the work for me.

My Question:
Can I utilize this add-in software to insert data into an existing empty table in a database housed on a remote server?

As is always the case in the technology world- I'm in a bit of a time crunch. I understand that my problem is not your emergency. However, any assistance in resolving this issue would be deeply appreciated!

Hi

Sorry for the delay.. My home computer has been down for the past while.. Eventually got around to fixing it today..!)

For that task, you cannot use the addin as it is only for retrieving data (at this point..)

However, you can use PHPMyAdmin (would normally be running on your remote mysql server).

Here are the steps I would follow:

(1) Take a backup of the database or at least the table you want to upload to. This is the most import thing. It is a good idea to take a copy and load it into Excel (very good way to check that your new data is formatted correctly).

(2) Before uploading any data you need to set up your Excel data appropriately. The Excel worksheet should correspond to a table in the database. In your Excel spreadsheet, make sure you create the same number of columns as exist for the corresponding database tables and make sure the columns are in the same order as shown by the phpmyadmin interface.

(2) Export / save the Excel worksheet with the data using the Comma Seperated Values (CSV) format. This will enable you to import the data into the database.

(3) Login to your database using PHPMYAdmin

(4) To import data into a database table you firstly need to click on that table's name in the phpmyadmin interface. You then need to click on "Import" at the top of the main window. This provides the interface through which you can upload data to the table you have selected.

(5) Click on "Browse..." to locate the .csv file you wish to upload. Then select "CSV" as the Format of imported file. Under CSV options, "Fields terminated by" should be changed to a comma. "Column names" can be left blank (assuming your Excel spreadsheet contained the same columns in the same order as the corresponding database table). Click on "Go" and the file will be imported.

(6) Now you should be all set but if there is any problem you can always go back and delete all the records from the table and start over..(Upload a new CSV File)

Hopefully the above will work for you. Please let me know how it goes. Thanks, Al