RSS Feed
Knowledgebase : Tutorials > Microsoft Products
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 to update the account number in QB from a table that I built in Access. In Access I linked the QB Accoun...
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 ...
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...
SAMPLE CODE FOR VB.NET WITH QODBC SAMPLE CODE OF VB.NET TO CREATE DATASET NOTE: The following code is the minimal code required to create a DataSet from the SQL statement and attaches the dataset to a DataGrid. Dim cnQODBC As System.Data.Odbc.OdbcCon...
HOW TO USE PROMPTED DATE RANGES IN MS ACCESS 2007 USING VISTA CREATE A LINK 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 S...
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...
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...
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 either as tables or as mail-merged fields. Open the Document y...
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 Excel MICROSOFT EXCEL 2010 AND QODBC 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-CONF...
QODBC AND MICROSOFT ACCESS 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/2435/57/HOW-TO-CONFIGURE-QODBC-TO-WORK-WITH-64-BIT...
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 any other language that supports COM components. CONNECTIO...
TROUBLESHOOTING: QUICKBOOKS DATA RETURN AS NULL(NVARCHAR ONLY) WITH SSIS PROBLEM DESCRIPTION We are using QODBC driver for connecting QuickBooks with SSIS. I can able to connect with QuickBooks through SSIS. But Quick books Ex: LIST ID) nvarchar data c...
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 to accomplish that. HOW TO EXTRACT SP_REPORTS USING MICROSOFT EXCEL 2007 OPEN MIC...
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 worlds are kept totally separate in the Microsoft Windows Operating System. QuickBooks is a 32-bit application, ...
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 worlds are kept totally separate in the Microsoft Windows Operating System. QuickBooks is a 32-bit application, so in ...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2007 CREATING A TABLE IN MICROSOFT ACCESS Open MS Access 2007, create a blank database. Click on "Create" button. Then you get a Microsoft Office Access blank database. The newly created database shall have one...
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 EXCEL 2016 / 365 / 2013 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-...
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 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 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 2016 / 365 / 2013 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-ACCES...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 TO IMPORT QUICKBOOKS DATA USING IMPORT TABLES NOTE: Microsoft Access is a product with many uses, and will allow you to use your QuickBooks data files in the same fashion as Access databases. Ope...
QODBC and Microsoft Excel MICROSOFT ACCESS 2003 AND QODBC CREATING A TABLE IN MICROSOFT ACCESS NOTE: Microsoft Access is a product with many uses, and will allow you to use your QuickBooks data files in the same fashion as Access databases. Selecti...
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...
ACCESSING QUICKBOOKS DATA WITH QODBC DRIVER USING MS EXCEL 2010 & MS ACCESS 2010 Sample Files : Excel - Customer & Company Tables - Download [1] Excel - Majority of the Tables and Reports - Download [2] Links: ------ [1] http://support.flexquar...
How to build 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]
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 USE QODBC EXCEL TEMPLATE  You can download the QODBC Excel Template, which has a majority of the tables and reports preconfigured. All you have to do is download the Excel Template and copy the file to Default Template folder To download the ...
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. Solution to this issue is to re-create the linked table. Ope...
SETUP QODBC TO WORK WITH MICROSOFT EXCEL POWERPIVOT 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 ...
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...
QODBC does support standard SQL queries, but the function is implemented differently. Please refer below functions & try to execute it in VB Demo application. FUNCTIONS IN SELECT QUERY: You can use distinct like: SELECT DISTINCT CustomerRefFullName ...
HOW CAN I USE SAME EXCEL FILES IN 64 & 32-BIT SYSTEMS PROBLEM DESCRIPTION: How Can I use 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 system? I...
HOW TO CREATE 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 Select...
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 DESCRI...
HOW TO CREATE AN ITEM INVENTORY ASSEMBLY THROUGH MS ACCESS USING QODBC AN EXAMPLE OF CREATING ONE ITEMINVENTORYASSEMBLY WITH TWO LINES First of all please create new MS Access database & link ItemInventoryAssembly, ItemInventoryAssemblyLine table. Pl...
EXAMPLES OF CREATING INVOICE USING QODBC First of all please create new MS Access database & link ALL table. Please refer below mentioned article for How to Use QODBC with Microsoft Access: How to Use QODBC with Microsoft Access [http://support.flexqua...
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 feed thes...
HOW TO USE MS ACCESS AS MIDDLEWARE WITH QODBC PROBLEM DESCRIPTION: When using Prepared Statements with QRemote driver then it throws an error called ODBC driver not supported. How can I use Prepared Statements with QODBC/QRemote? SOLUTIONS: You may...
QODBC SHOWS 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 AS SOON AS TRYING TO ...
PROBLEM DESCRIPTION: We modified an invoice in QuickBooks and we are trying to get the data out in Excel, but QODBC gives us the old data still. Why? SOLUTIONS: QODBC failed to return full records is usually caused by either corruption of QODBC opti...
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 MS Access database & linked all QODBC tables through QRemote DSN, After that...
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 - MULTIPLE TABLES EXIST ERROR IN 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 been t...
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...
QODBC POS COULD NOT ACCESS TO QUICKBOOKS POS COMPANY FILE PROBLEM DESCRIPTION: When set QODBC POS DSN to access the company file that is running in QuickBooks POS (Version 10), it will fail to connect to the company file. QuickBooks POS will search for ...
TROUBLESHOOTING - "ERROR PARSING COMPLETE XML RETURN STRING" ERROR WHEN TRYING TO UPDATE TABLE PRICELEVELPERITEM IN MS ACCESS PROBLEM DESCRIPTION: I have constructed an Access database file (in 32bit Access 2003) with tables linked to QuickBooks. I can ...
TROUBLESHOOTING - HOW TO USE DATE() AND DATEADD() FUNCTION IN QODBC PROBLEM DESCRIPTION: I want to write some select statements on both InvoiceLine and SalesReceiptLine that returns all records dated WITHIN the past 30 days, relative to whatever TODAY ...
HOW TO USE QXL STEP 1 - DOWNLOAD QXL If you haven't already downloaded QXL, do it now by going to the download page [http://qxl1.com/qxl-for-quickbooks-desktop-downloads/]. Don't forget to read the "Readme" file during installation for the latest infor...
PROBLEM DESCRIPTION: How to use parameter 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 = '19...
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...
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 Order...
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 ...
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 Online...
REFRESH ON MS EXCEL FAILS PROBLEM: MS Excel shows data protection error when we click on "Refresh All" link. When you click on "OK" you will see below error. SOLUTION: You are receiving this error because your Excel sheet is in PROTECTED MODE. Wh...
TROUBLESHOOTING - AUTO LOGIN AS SERVICE AND SYNCING TABLES TO SQL SERVER PROBLEM DESCRIPTION: So the QODBC works great running on the machine. We have the intent to integrate into our website / Intranet to create customers or make changes from the web...
TROUBLESHOOTING - THIS RECORD HAS BEEN CHANGED BY ANOTHER USER SINCE YOU STARTED EDITING IT. PROBLEM DESCRIPTION: I am using the QuickBooks Pro 2015 trial version and a purchased QODBC latest version. I have an Access database with linked QB tables. ...
HOW TO IMPORT DATA TO QUICKBOOKS THROUGH CSV USING QODBC NOTE: QODBC does not support direct import, But you can write VBA code which reads a CSV / Excel file & generates insert statements. There are two ways to Import data to QuickBooks through CSV u...
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...
TROUBLESHOOTING - GETTING ERROR "INDEX WAS OUTSIDE THE BOUNDS OF THE ARRAY." WHEN USING IMPORT/EXPORT TOOL IN SQL SERVER PROBLEM DESCRIPTION 1: I just recently installed QODBC to try to get data out of a QuickBooks company file but I get this error: "...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 64-BIT FOR 32-BIT, PLEASE REFER: 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 MICROSOF...
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...
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 SSIS Either QODBC or QRemote is required on the machine where SSIS package will be developed, deployed or SSIS services are installed. Development - On the machine, you are developing SSIS package - You should have QODBC install...
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 New Standard EXE ...
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 that it can connect only 1 company fil...
EXCEL AUTOMATION - HOW TO OPEN, REFRESH AND CLOSE A COMPANY FILE Download Sample [http://support.flexquarters.com/esupport/newimages/ExcelAutomation/ExcelAutomation.zip] Before using MS Excel application, please make sure you have installed MS Office C...
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 How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote [http://suppor...
ACCESSING QUICKBOOKS DATA REMOTELY VIA SQL SERVER First, you need to create Linked Server in SQL Server. For 32-bit SQL Server. Please refer How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote [http://support.flexquarters.co...
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...
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 ...