Using An Excel Spreadsheet To Feed A Custom Sql Statement 关注
We currently have a label that prompts for ItemID and places it in a Custom SQL Statement data connection and prints the label (iz.ItemID = '?Enter ItemID'). Now I am being asked to use the same label but instead of prompting for each ItemID they want it to pull from an Excel spreadsheet of ItemIDs. So it will print a label for every ItemID in the spreadsheet using the custom sql data connection.
Can this be done?