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:
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
Bookmarks