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 6345)

External Product Source - ODBC Link to DBF File

This information applies to :

Article ID
6345

Created/Updated
July 17, 2019

Category
Product Database

Are you using the most current release of QuoteWerks?
Version 24.0 Build 2
Issue:
How do you create a link to a DBF File as a Product Source with the Professional or Corporate Edition of QuoteWerks?


Solution - Microsoft dBase Driver

On the ODBC Login Screen when setting up the datasource, leave all fields as default.

1. Change the Driver to 'Microsoft dBase Driver (*.dbf)'
2. Press the Advanced Button and Add Values for dbq="***Ful Path to Folder Containing the DBF ***" and DriverID = 227



Solution - Microsoft Visual FoxPro Driver

On the ODBC Login Screen when setting up the datasource, leave all fields as default.

1. Change the Driver to 'Microsoft dBase Driver (*.dbf)'
2. Press the Advanced Button and Add Values for dbq="***Ful Path to Folder Containing the DBF ***" and SourceType = DBF

New Search

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