RSS Feed
Knowledgebase : Tutorials > Microsoft Products
     

SOLVED:[QODBC-ALL] TROUBLESHOOTING - WINDOWS CANNOT FIND FQQBSAV.EXE  PROBLEM DESCRIPTION Issue 1: I just updated QODBC to the latest build, 349. When trying to connect to the QRemote DSN, I get the following error message. Windows cannot find 'fqqb...
USING QODBC WITH OFFICE 64-BIT QuickBooks is a 32-Bit application, but other applications such as MS Excel, MS Access, and MS SQL Server are also available in 64-Bit architecture. Since a 64-Bit application cannot talk to a 32-bit driver, we have to d...
HOW TO USE POWERSHELL WITH QODBC Download Sample [http://support.flexquarters.com/esupport/newimages/PowerShell/DisplaySQL.zip] SAMPLE CODE FOR USING QODBC DSN: $connectstring = "DSN=QuickBooks Data;" $sql = "Select TOP 10 Name from Customer" $conn ...
TROUBLESHOOTING - UPDATE FROM A SELECT STATEMENT NOT WORKING PROBLEM DESCRIPTION: I am trying to update records through the select statement. But it is not working. UPDATE Customer SET CustomFieldProjectNumber = i.JobNumber FROM ( SELECT ListID, {fn...
ACCESSING QUICKBOOKS DATA REMOTELY VIA SQL SERVER First, you need to create Linked Server in SQL Server. For 32-bit SQL Server. Please refer to How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote [http://support.flexquarters...
HOW TO IMPORT QUICKBOOKS DATA TO SQL SERVER DATABASE (LOCAL TABLE) First, you need to create Linked Server in SQL Server. For 32-bit SQL Server. Please refer to How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote [http://sup...
EXCEL AUTOMATION - HOW TO OPEN, REFRESH AND CLOSE A COMPANY FILE Download Sample [http://support.flexquarters.com/esupport/newimages/ExcelAutomation/ExcelAutomation.zip] Before using the MS Excel application, please ensure you have installed the MS Off...
CONNECTING MULTIPLE QUICKBOOKS COMPANIES VIA EXCEL Download Sample [http://support.flexquarters.com/esupport/newimages/MultipleCompany/MultipleQBCompanyConnection.zip] There is a limitation with the QuickBooks SDK: it can connect only one company file ...
USING ADODC AND ADODB WITH QODBC Download Sample [http://support.flexquarters.com/esupport/newimages/VB6/QODBCVB6.zip] ADODB WITH QODBC Open VB6, you can find it via Windows Start->All Programs->Microsoft Visual Studio 6.0 : Create a New Standard EX...
HOW TO USE QODBC WITH SSIS Either QODBC or QRemote is required on the machine where the SSIS package will be developed and deployed, or SSIS services are installed. Development - On the machine, you are developing, the SSIS package should have QODBC ...
SAMPLE CODE FOR C++ WITH QODBC #include #include #include #include #include #include #include #include using namespace std; void ConvertTimeStampStructToString(TIMEST...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2016 (64-BIT) FOR MS ACCESS 64-BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2771] SETUP QODBC TO US...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 64-BIT FOR 32-BIT, PLEASE REFER: TO HOW TO CONFIGURE QODBC TO WORK WITH 32-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2470]. CREATING A TABLE IN MICR...
TROUBLESHOOTING - GETTING ERROR "INDEX WAS OUTSIDE THE ARRAY BOUNDS." WHEN USING THE IMPORT/EXPORT TOOL IN SQL SERVER PROBLEM DESCRIPTION 1: I recently installed QODBC to get data out of a QuickBooks company file, but I get this error: "Index was outs...
HOW TO USE QODBC WITH MS EXCEL POWER QUERY NOTE: QODBC allows you to quickly merge live QuickBooks data into the cells of your Microsoft Excel worksheets for quick calculations and graphs. The data will retain a live link to QuickBooks, and one click wi...
HOW TO IMPORT DATA TO QUICKBOOKS THROUGH CSV USING QODBC NOTE: QODBC does not support direct import, But you can write VBA code that reads a CSV / Excel file & generates insert statements. There are two ways to Import data to QuickBooks through CSV us...
TROUBLESHOOTING - ANOTHER USER HAS CHANGED THIS RECORD SINCE YOU STARTED EDITING IT. PROBLEM DESCRIPTION: I used the QuickBooks Pro 2015 trial version and purchased QODBC's latest version. I have an Access database with linked QB tables. I also have ...
TROUBLESHOOTING - AUTO LOGIN AS SERVICE AND SYNCING TABLES TO SQL SERVER PROBLEM DESCRIPTION: So the QODBC works excellently running on the machine. We intend to integrate into our website / Intranet to create customers or make changes from the web. I...
REFRESH ON MS EXCEL FAILS. PROBLEM: MS Excel shows a data protection error when we click on the "Refresh All" link. When you click "OK," you will see the error below. SOLUTION: You are receiving this error because your Excel sheet is in PROTECTED M...
CONNECTING QODBC ONLINE DRIVER TO QUICKBOOKS ONLINE FOR THE FIRST TIME  (VIDEO) For system requirement details of QODBC Online, click here [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2816]. How to install QODBC Onlin...
EXAMPLES OF CREATING INVOICE USING QREMOTE FROM SQL SERVER NOTE: For multi-line invoices, some may find it easier to NOT include the header information with each line item, but rather to have separate smaller commands for the Invoice Lines and a final ...
TROUBLESHOOTING - QREMOTE DOES NOT CONSIDER FQSAVETOCACHE WITH WORKING WITH ODBCCOMMAND & PARAMETERS PROBLEM DESCRIPTION: QRemote Does not consider FQSaveToCache with working with OdbcCommand & Parameters. I have an application that creates Sales Orde...
TROUBLESHOOTING - GETTING MULTIPLE-STEP OLE DB OPERATION GENERATED ERRORS IN SQL SERVER PROBLEM DESCRIPTION: Trying to insert into SalesOrderLine and getting a 'Multiple-step' error. INSERT INTO QBREMOTE...SalesOrderLine (CustomerRefListID, TemplateR...
PROBLEM DESCRIPTION: How to use parameters in OPENQUERY SOLUTIONS: OPENQUERY does not accept variables for its arguments. You need to Pass Basic Values as below example: SELECT QUERY: DECLARE @TSQL VARCHAR(8000), @ID VARCHAR(25) SELECT @ID = '1...
HOW TO USE QXL STEP 1 - DOWNLOAD QXL If you haven't already downloaded QXL, go to the download page [http://qxl1.com/qxl-for-quickbooks-desktop-downloads/] now. Don't forget to read the "Readme" file during installation for the latest information on QX...
TROUBLESHOOTING - HOW TO USE DATE() AND DATEADD() FUNCTION IN QODBC PROBLEM DESCRIPTION: I want to write some select statements on InvoiceLine and SalesReceiptLine that return all records dated WITHIN the past 30 days relative to whatever TODAY is. I'm...
TROUBLESHOOTING - "ERROR PARSING COMPLETE XML RETURN STRING" ERROR WHEN TRYING TO UPDATE TABLE PRICELEVELPERITEM IN MS ACCESS PROBLEM DESCRIPTION: I constructed an Access database file (32bit Access 2003) with tables linked to QuickBooks. I can pull inf...
QODBC POS COULD NOT ACCESS TO QUICKBOOKS POS COMPANY FILE PROBLEM DESCRIPTION: When ting sets QODBC POS DSN to access the company file running in QuickBooks POS (Version 10), it will fail to connect to the company file. QuickBooks POS will search for th...
TROUBLESHOOTING - CANNOT USE ALIAS IN MS QUERY PROBLEM DESCRIPTION: I am getting the below error message when trying to SELECT data fields AS Alias, the statement runs fine otherwise. [sql syntax error] Expected lexical element not found:= Please se...
TROUBLESHOOTING - MULTIPLE TABLES EXIST ERROR IN THE LINKED SERVER PROBLEM DESCRIPTION: I am trying to run a query using an SQL Server database link to QuickBooks using QRemote. I can set up the linked server fine in SQL Server, and the connection has b...
TROUBLESHOOTING - MS ACCESS CRASHES HARD ON DATE QUERY PROBLEM DESCRIPTION: I've linked all the QODBC tables into an Access 2010 DB. I have created table subset queries on the original tables and would like to do selects based on date ranges - other thi...
TROUBLESHOOTING: MS ACCESS AS MIDDLEWARE IS NOT WORKING WITH MS SQL SERVER PROBLEM DESCRIPTION: I am trying to use MS Access as a middleware with MS SQL Server. I have created an MS Access database & linked all QODBC tables through QRemote DSN. After t...
PROBLEM DESCRIPTION: We modified an invoice in QuickBooks and are trying to get the data out in Excel, but QODBC gives us the old data. Why? SOLUTIONS: QODBC failure to return full records is usually caused by corruption of the QODBC optimizer file....
QODBC SHOWS A REGFILE1 LICENSE ERROR WHEN USING MS EXCEL 2013 OR ACCESS 2013  MS EXCEL 2013 OR ACCESS 2013 SHOWS THIS FUNCTION REQUIRES ACTIVATION OF QODBC READ WRITE OR SERVER EDITION. MS EXCEL 2013 OR ACCESS 2013 (OFFICE 365) CRASHES WHEN TRYING TO CO...
HOW TO USE MS ACCESS AS MIDDLEWARE WITH QODBC PROBLEM DESCRIPTION: When using Prepared Statements with the QRemote driver, it throws an error called ODBC driver not supported. How can I use Prepared Statements with QODBC/QRemote? SOLUTIONS: You may...
QUESTION: I've built a table in Access of invoice lines to be added to existing invoices. I have the TxnID and all the necessary xxxxListID fields etc., with the item, quantity, and values coming from other sources. So "all" I have to do now is to feed t...
EXAMPLES OF CREATING INVOICE USING QODBC First, please create a new MS Access database & link ALL tables. Please refer to the below-mentioned article for How to Use QODBC with Microsoft Access: How to Use QODBC with Microsoft Access [http://support.fle...
HOW TO CREATE AN ITEM INVENTORY ASSEMBLY THROUGH MS ACCESS USING QODBC AN EXAMPLE OF CREATING ONE ITEMINVENTORYASSEMBLY WITH TWO LINES First, please create a new MS Access database & link ItemInventoryAssembly, and ItemInventoryAssemblyLine tables. P...
USING QUICKBOOKS DATA WITH VBA FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2472/57/MICROSOFT-ACCESS-2003-AND-QODBC]. PROBLEM DESCR...
HOW TO CREATE A LINK SERVER WITH MS SQL 2005/2008/2012 64-BIT USING QODBC POS/QREMOTE Start your "SQL Server Management Studio" Login to your SQL Server. On the left-hand side panel, you will find the Server, Right Click on the "SQL Server" and Sele...
HOW CAN I USE THE SAME EXCEL FILES IN 64 & 32-BIT SYSTEMS PROBLEM DESCRIPTION: How Can I use the same Excel files in 64 & 32-bit Systems? Is it possible to have a connection setup in an Excel file and be able to refresh on either a 64 or 32-bit syst...
QODBC does support standard SQL queries, but the function is implemented differently. Please refer to the below functions & try to execute them in QODBC TEST TOOL. FUNCTIONS IN SELECT QUERY: You can use distinct like: SELECT DISTINCT CustomerRefFull...
USING QUICKBOOKS POS DATA WITH ACCESS 2013 (LINKED TABLES) 32-BIT FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2472/57/MICROSOFT-ACC...
SETUP QODBC TO WORK WITH MICROSOFT EXCEL POWERPOINT NOTE: QODBC allows you to quickly merge live QuickBooks data into the cells of your Microsoft Excel worksheets for quick calculations and graphs. The data will retain a live link to QuickBooks, and one-...
HOW TO GET UPDATED CUSTOM FIELD WITH MS-ACCESS (LINKED TABLE) IN QUICKBOOKS New Custom Fields are created within QuickBooks. In MS Access Newly created Custom Fields are not visible. The solution to this issue is to re-create the linked table. ...
HOW TO USE THE QODBC EXCEL TEMPLATE  You can download the QODBC Excel Template, which has most of the tables and reports preconfigured. All you have to do is download the Excel Template and copy the file to the Default Template folder. To download t...
HOW TO CREATE LINK SERVER WITH MS SQL 2005/2008/2012/2016 32-BIT USING QODBC/QREMOTE For 64-bit Refer: How to create Link Server with MS SQL 2005/2008/2012/2016 64-bit Using QODBC/QRemote [http://support.flexquarters.com/esupport/index.php?/Default/Knowl...
How to build a QuickBooks IIS Web application using QODBC Driver and Microsoft ASP.NET (Video) Download the sample code: Click Here [http://support.flexquarters.com/supportfiles/QODBC%20onASP.NET.zip] Also, refer to Sample C#.NET Web Application for ...
ACCESSING QUICKBOOKS DATA WITH QODBC DRIVER USING MS EXCEL 2010 & MS ACCESS 2010 (VIDEO) - 32-BIT ACCESSING QUICKBOOKS DATA WITH QODBC DRIVER USING MS EXCEL 2010 & MS ACCESS 2010 (VIDEO) - 64-BIT (MINIMUM REQUIREMENT: QUICKBOOKS 2022 64-BIT AND QODBC 202...
QODBC and Microsoft Excel MICROSOFT EXCEL 2003 AND QODBC Also, Refer: How to Use QODBC with MS Excel 2007 [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2449/57/how-to-use-qodbc-with-ms-excel-2007] Using QuickBo...
QODBC and Microsoft Excel MICROSOFT ACCESS 2003 AND QODBC CREATING A TABLE IN MICROSOFT ACCESS NOTE: Microsoft Access has many uses and will allow you to use your QuickBooks data files similarly to Access databases. Selecting the menu FILE -> NEW -...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019 32-BIT TO IMPORT QUICKBOOKS DATA USING IMPORT TABLES HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019 64-BIT TO IMPORT QUICKBOOKS DATA USING IMPORT TABLES (MINIMUM REQUIREMENT...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019 32-BIT HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019 64-BIT (MINIMUM REQUIREMENT: QUICKBOOKS 2022 64-BIT AND QODBC 2023)   QuickBooks 2022 and above are 64-Bit applicatio...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2010 (32-BIT) TO IMPORT QUICKBOOKS DATA FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2435/57...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2010 TO BUILD LINKED TABLE(32-BIT) FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2435/57/HOW-...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2010 (32-BIT) FOR MS ACCESS 64-BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS EXCEL [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2441/57/HOW-TO-CONFIGURE-...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2016 / 365 / 2013 / 2019 32-BIT HOW TO USE QODBC WITH MICROSOFT EXCEL 2016 / 365 / 2013 / 2019 64-BIT (MINIMUM REQUIREMENT: QUICKBOOKS 2022 64-BIT AND QODBC 2023)   QuickBooks 2022 and above are 64-Bit applications...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2007 SETUP QODBC TO WORK WITH MICROSOFT OFFICE 2007 NOTE: QODBC allows you to quickly merge live QuickBooks data into the cells of your Microsoft Excel worksheets for quick calculations and graphs. The data will ret...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2007 CREATING A TABLE IN MICROSOFT ACCESS Open MS Access 2007, and create a blank database. Click on the "Create" button. Then you get a Microsoft Office Access blank database. The newly created database shall ...
How to Get QODBC to go with 64-bit Access and Excel HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS EXCEL INSTRUCTIONS 64 and 32-bit words are kept separate in the Microsoft Windows Operating System. QuickBooks 2021 and older versions are 32-bit appli...
How to Get QODBC to go with 64-bit Access and Excel HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MICROSOFT ACCESS INSTRUCTIONS 64 and 32-bit words are kept separate in the Microsoft Windows Operating System. . QuickBooks 2021 and older versions are 32-b...
HOW TO CREATE SP_REPORTS USING MICROSOFT EXCEL 2007 INSTRUCTIONS To extract sp_reports from QuickBooks into Microsoft Excel Spreadsheet, you should use MICROSOFT QUERY. HOW TO EXTRACT SP_REPORTS USING MICROSOFT EXCEL 2007 OPEN MICROSOFT QUERY IN EXC...
TROUBLESHOOTING: QUICKBOOKS DATA RETURN AS NULL(NVARCHAR ONLY) WITH SSIS PROBLEM DESCRIPTION We are using the QODBC driver for connecting QuickBooks with SSIS. I can able to connect with QuickBooks through SSIS. But Quick books Ex: LIST ID) nvarchar da...
HOW TO USE ADO AND VISUAL BASIC WITH QODBC SETUP QODBC TO WORK WITH ADO NOTE: QODBC can be accessed from ADO. ADO can be used in Visual Basic (VB), Access, VBScript, ASP, C++, VB.NET, C#, and other languages that support COM components. CONNECTION S...
QODBC AND MICROSOFT ACCESS FOR MS ACCESS 64-BIT, PLEASE REFER: TO HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2435/57/HOW-TO-CONFIGURE-QODBC-TO-WORK-WITH-64-...
QODBC and Microsoft Excel MICROSOFT EXCEL 2010 AND QODBC FOR MS ACCESS 64-BIT, PLEASE REFER: TO HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS EXCEL [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2441/57/HOW-TO-C...
Microsoft Office with MS Query and QODBC MICROSOFT OFFICE WITH MS QUERY AND QODBC SETUP QODBC TO WORK WITH MICROSOFT OFFICE Before using any Microsoft Office applications, you must ensure that the Microsoft Query builder is installed. Click START ...
QODBC and Microsoft Word MICROSOFT WORD 2003 AND QODBC CREATING A WORD MAIL MERGE TO LIVE QUICKBOOKS DATA NOTE: QODBC allows you to easily merge QuickBooks data onto your Word documents as tables or mail-merged fields. Open the document you wish to...
QODBC AND SHAREPOINT ENVIRONMENT DESCRIPTION QuickBooks Enterprise 2017 Microsoft SharePoint 2006 / SharePoint 2016 / SharePoint Foundation / SharePoint Office 365 INSTRUCTIONS The use of SharePoint Services requires the full QODBC Server Editio...
HOW TO USE PROMPTED DATE RANGES IN MS ACCESS CREATE LINK TABLE Let's start from the beginning. Open MS Access -> Create a blank database -> Using the FILE menu pulldown -> GET EXTERNAL DATA -> select LINK TABLES... Select Files of type: ODBC DATAB...
HOW TO USE PROMPTED DATE RANGES IN MS ACCESS 2007 USING VISTA CREATE A LINK TO TABLE Let's start from the beginning. Open Microsoft Access 2007 -> Create a Blank Database: Using the EXTERNAL DATA tab -> use the More icon and select: ODBC DATABASE ...
SAMPLE CODE FOR VB.NET WITH QODBC SAMPLE CODE OF VB.NET TO CREATE DATASET NOTE: The following is the minimal code required to create a DataSet from the SQL statement and attach the dataset to a DataGrid. Dim cnQODBC As System.Data.Odbc.OdbcConnection...
EXAMPLES OF HOW TO USE QODBC VIA VISUAL BASIC DOWNLOAD LINK QUERY AND UPDATE VBS Click here: http://www.qodbc.com/docs/support/vbexamples.zip [http://www.qodbc.com/docs/support/vbexamples.zip] to download some VBS files that show several examples of q...
HOW TO USE PROMPTED DATE RANGES IN MS EXCEL NEW DATABASE QUERY Let's start from the beginning. Open MS Excel -> Using the DATA menu pulldown -> IMPORT EXTERNAL DATA -> select NEW DATABASE QUERY... LOCATE TABLE AND FIELD RECORD Select Databases ...
EXAMPLE CODE OF UPDATE QUICKBOOKS FROM MS ACCESS REQUIREMENTS OF UPDATE QB FROM MS ACCESS Now take below as an example: All I am trying to do is update the account number in QB from a table I built in Access. In Access, I linked the QB Account table...