407-248-1481
QuoteWerks Turkey Logo - QuoteWerks Sales Quoting and Proposal Software - CPQ that integrates with leading CRM, PSA, and Accounting Solutions (ConnectWise, Autotask, QuickBooks, salesforce.com and more)
Request a Demo
Customer Area

QuoteWerks Knowledgebase Topic (Article ID 6237)

Error with Quick Lookup Feature and Linked Excel Product Source

This information applies to :

Article ID
6237

Created/Updated
July 17, 2019

Category
Importing

Are you using the most current release of QuoteWerks?
Version 24.0 Build 4
Issue:

I am getting the following errors when trying to use Quick Lookup Feature to add a part from a linked MS Excel Spreadsheet/product source:

"dcFindProduct":"Data type mismatch in criteria expression""OK"

"QuoteWerks": "Error in FindProductRecord""Error (-2147217913) Automation error"
"SQL=SELECT * FROM [{Data$Print_Area}]Where[{column heading}]"{part no}"

stuff in {}





Cause:

We have observed that when linking to MS Excel as a product source, this error occurs when the manuafacturer part number consists of ONLY numbers. This only affects the Quick Lookup feature

For example:

-Part number 1234 would cause this error
- Part number 1234A woud NOT cause this error.

Solution:

If you don't want to change/modify your manufacturer part numbers, I recommend you save your Excel spreadsheet in CSV format and import the file directly into QuoteWerks.

New Search

  •            
©1993-2024 Aspire Technologies, Inc.
    407-248-1481 (9am-5pm ET M-F)