I'm just using the Microsoft Query Wizard to set up the select statement. To keep it brief for testing, I'm only returning two fields in this query. SELECT itmnum, sdesc FROM ivpitems WHERE itmnum=?
I'm really at a loss here and it seems to be such a simple task that I must be missing the forest for the trees. I am given an excel 2007 worksheet with columns of part numbers, descriptions etc. which usually is no more than one hundred rows. I need to access an external database AS400(DB2) and...