hi,
you left out something. where are you getting the data to insert?

Regards
FSt1

"mooreeasyvibe" wrote:


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


--
mooreeasyvibe
------------------------------------------------------------------------
mooreeasyvibe's Profile: http://www.excelforum.com/member.php...o&userid=26818
View this thread: http://www.excelforum.com/showthread...hreadid=400728