How to create insert statements?
 

Hi,

I'm a bit of a newbie to excel and was wondering if anyone can help m
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, 'remot
control');
insert into category_lookup (productid, category) values (2, 'remot
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 i
needed.

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

Hope you can help

Thanks

Chri

--
mooreeasyvib
-----------------------------------------------------------------------
mooreeasyvibe's Profile: http://www.excelforum.com/member.php...fo&userid=2681
View this thread: http://www.excelforum.com/showthread.php?threadid=40072

How to create insert statements?
 

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

How to create insert statements?
 

All of the data will just be on an excel worksheet.

All I want to do is loop over each row in the sheet and write the
insert statements to an external file.

Thanks for your help

Chris


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