How to create insert statements?

mooreeasyvibe · August 31st, 2005, 06:00 AM

Hi,

I'm a bit of a newbie to excel and was wondering if anyone can help me create an insert script for my database?

At the moment on my worksheet I have the following:

Code:

productname    productid    remote control                 spy    fitness            other
testa                  1               1            
testb                  2               1                    1
testc                  3                                            1

I am looking to create this:

insert into category_lookup (productid, category) values (1, 'remote control');
insert into category_lookup (productid, category) values (2, 'remote control');
insert into category_lookup (productid, category) values (2, 'spy');
insert into category_lookup (productid, category) values (3, 'fitness');

and so on......

Basically a 1 in any of my categories means an insert statement is needed.

Does anyone know the simple vba to do this or a formula??

Hope you can help

Thanks

Chris