View Single Post
  #1 (permalink)  
Old May 18th, 2006, 19:11
jimmy_d jimmy_d is offline
New Member
Join Date: May 2006
Location: UK,Birmingham
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
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
Reply With Quote