j8547
asked on
vba code to query sql db from excel
I have an excel sheet with 2 rows of information. the first row is numbers/id's. I have a sql db with more information for each id. I want to query the db and for each id, to return the rest of the info into excel. So Select where id=value in the cells in the first column. I can conect to the db so that part is working but I can't / do not know how to fit in the where properly. so here is the way i think it has to be. I get the id in cell one, search through the whole datatbase for that id and return the results in the next columns. then i move on cells 2 and so on. any help is appreciated
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.