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