Print Wizard Query Numbers And Letters 关注
I am using Print Wizard Query to select specific records from an Excel DB (.xls). The query uses product item numbers, half of which are only numbers (e.g. 1234567), and the other half that use a single letter suffix "U" (e.g. 1234567U).
The Query doesn't recognize any of records with the "U" suffix, and when I go in to look at the database records through BT, those item numbers in the Excel file have been removed and the cells are empty. No other fields in the Excel file have had this issues and they're a combination of numbers, text, UPC codes, etc.
As the fields are empty, I then get an error code when I try to print with the Wizard: OLE DB OX80040E14, IDispatch Error #3092
Fernando Ramos Miracle版主