QuoteWerks Knowledgebase Topic (Article ID 6335)
Link to Excel - Error in FindProductRecord
This information applies to :
August 30, 2006
When Linking to an Excel file for Products, and the Print Picture is mapped to a column that contains 'Y' and PictureFileName is mapped to 'DVD.BMP' and 'DVD.BMP' is located in the images folder of the QuoteWerks directory, the following messages are received and then the preview occurs without the picture:
Data type mismatch in criteria expresion.
-Message 2 (This message will differ slightly depending on your Excel File)-
Error in FindProductRecord
Error (-2147217913) Automation error
SQL=SELECT * FROM [Sheet1$] WHERE F2='101'
The field in Excel that holds the Manufacturer Part Number is a Numeric Field. This field should be text.
To resolve this issue, make sure that the column in Excel that holds the Manufacturer Part Number is a Text Field.
©1993-2020 Aspire Technologies, Inc.
407-248-1481 (9am-5pm ET M-F)