Update Data With SQLScripts Created In Excel

**redsunflower** · 18 Mar 2006, 04:16 PM

Originally posted by JuxiZoza@May 5 2005, 03:08 PM

It addresses UPDATING your tables, not INSERTING new records. I never finished the 'inserting new records' addendum that I was working on.
But, that has not prevented numerous users from adapting their worksheets to do that.

I've managed (finally) to get my update scripts working,

but can't seem to get it to upload any new stock I have.
I've tried changing the 'UPDATE products SET' to say 'INSERT products SET' but this bring back an error. I'm probably just being blonde! ::frust

I'm fine with anything in excel but fairly new to SQL codes. Can anyone give me a couple of pointers as to what i need to change to get my products inserted rather than just updated.

Any help is greatly appreciated!

Zen Cart is fantastic even if it is a steep learning curve (feels more like a cliff!!)

THANKS

**zencoder** · 18 Mar 2006, 08:02 PM

Somebody please answer this query of mine

http://www.zen-cart.com/modules/ipb/index....showtopic=44458

**dwno** · 18 Mar 2006, 08:36 PM

Originally posted by redsunflower@Mar 18 2006, 04:16 PM
I've tried changing the 'UPDATE products SET' to say 'INSERT products SET' but this bring back an error. I'm probably just being blonde! ::frust

That's not the way to insert rows.
INSERT syntax
UPDATE syntax

**redsunflower** · 19 Mar 2006, 12:55 PM

THANKS Dwno - that's exactly what I needed. You were a great help! ::tup
Wish me luck x

**manish** · 23 Mar 2006, 05:16 AM

Hi Guys,

I have read the entire thread and am trying hard to understand uploading data by excel.

Need a small help. I am planning to create a shopping cart for selling Stock Images. I have same price for 3 types of attributes for these images.
To mass upload the data for a particular category which tables do I need to populate.

Thanks.