I have a spreadsheet that pulls data from a SQL database. Then I have a button that lets the user FTP the sheet to send the manipulated spreadsheet to a customer. What I need to do is take one column of the spreadsheet, take the unique values in it and either use it as where clause in a sql update back to the database or an insert statement. Either will work.
Sample Column Values
123456A
123455A
123445A
123345A
122345A
sSTRSQL = update tblOrders where OrderNumber in ('123456A','123455A','123445A','123345A','122345A')
or do a loop and insert each order number into a tracking table in the database
Can someone point me in the right direction on how to do that?
Sample Column Values
123456A
123455A
123445A
123345A
122345A
sSTRSQL = update tblOrders where OrderNumber in ('123456A','123455A','123445A','123345A','122345A')
or do a loop and insert each order number into a tracking table in the database
Can someone point me in the right direction on how to do that?