407-248-1481
QuoteWerks Logo - QuoteWerks Sales Quoting and Proposal Software - CPQ that integrates with leading CRM, PSA, and Accounting Solutions (ConnectWise, Autotask, QuickBooks, salesforce.com and more)
Start Free Trial
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 2
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)