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 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 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 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 ...
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.
The solution to this issue is to re-create the linked table.
...
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 to the below functions & try to execute it in QODBC TEST
TOOL.
FUNCTIONS IN SELECT QUERY:
You can use distinct like:
SELECT DISTINCT CustomerRefFullNa...
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 ma...
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 corruption of
the QODBC optimi...
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 return all records dated WITHIN the past 30
days, relative to whatever TODAY i...
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 ...
USING QODBC WITH OFFICE 64-BIT
QuickBooks is a 32-Bit application, but there are other applications
such as MS Excel, MS Access, and MS SQL Server which are also
available in 64-Bit architecture.
Since a 64-Bit application cannot talk to a 32-bit driv...
Help Desk Software by Kayako