simple file upload?

Read this in a previous thread:

"A more long winded way would be to set-up your database structure in MySQL, dump the data from Access as a CSV file, then upload the CSV file into MySQl."

I have the structure set up (by oscommerce) and need to load my data.

Managed it once, but then tried to change something and it all went wrong so I started again.

What I want to do is upload each field within my table individually from a saved file from excell in csv format.(is this the correct format to use?)

For example if the table included name image and price, and the prices increased by 10% then I could make the changes in excell and then upload all and ony "price" records to the db.

I don't have a need to learn php/sql at the moment so would like to use phpmyadmin.

I have tried to do this and can upload one set of records, but when I try to upload to a different field the records start from the last previosley entered record.ie upload name 1-100 then the prices would start at 101?

Thanx in advance
James

you cant upload and insert it one column at a time and i dont think its possible to update a row from a data import. is there any reason why you cant do all the columns in one go?

You need to get yourself a copy of SQLyog. I use this to manage my databases and it's absolutely brilliant.

http://webyog.com/

You'll be amazed at what you can do with this tool.

As you are going to be running this on your own machine, you will need to get your hosting provider to give you remote access but that shouldn't be a problem.

You can update single columns and you have control over whether to append or update existing, etc, etc.

Thanx for the info,
I have sqlylog but didn't use because of the remote access
so I shall contact the hosting providor to enable this.

Or from izone reply I could craete and update the table in excell and
upload all in one go.

Thanx
James