Knowledgebase
[QODBC-Desktop] Using QuickBooks Data with Access 2010 (Import Tables) 32-bit
Posted by Rajendra Dewani (QODBC Support) on 12 November 2012 02:15 PM

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

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.

Open MS Access 2010, and make sure you are using the 32-bit version of MS Access:

Then create a blank database from "File" -> "New":

A default database filename, Database1, appears in the box. You can edit this to a more relevant name, such as QB Link. accdb. Save the file as type "Microsoft Office Access Databases."

Then Click "Create" to create a blank database:

In the newly created database, you will find a default blank table. Please close this table:

 

Build a connection via External Data->More->ODBC Database, or directly click the ODBC database button at the External Data menu:

Under the Get External Data window, you will see two options:

Import the source data into a new table in the current database. This option will directly extract tables into Access Database, you can view and edit these tables, but all modifications will not be uploaded unless you build another query.

Link to the data source by creating a linked table: this option will create a table just like the first option but will keep its link to QuickBooks, which means all your operations to this table will be uploaded to QuickBooks, and the data in the table is also in full sync with QuickBooks.

This article will show you how to import data from QuickBooks into MS Access.

Import Data from QuickBooks

After you select the access method and click OK, then you will get a Select Data Source window:

Select the QuickBooks-related DSN you set up with the QODBC driver. This can be one of our pre-installed DSN names or one that you have created. (Here, I choose the default DSN as the example.)

The first time you use MS Access to access QuickBooks, it will ask you to grant permission for this application:

Select the "Yes, Always" option, and then click "Done" in the next window:

Once the connection is built, Access will return a list of available tables in the Select Tables window. Please, select the tables you want to extract. Multiple Selection is available.

After all the tables are successfully imported with no errors, you will get a window reporting successful:

You will see those imported tables under the "Tables" list:

Double-click the table to view the data:

These import records are stored as MS Access tables so that you can change the schema rules of these tables. Please remember these tables do not sync back to QuickBooks. Thus all the modifications you do to these tables will NOT be updated in QuickBooks.

 


Note: When you run across an application that is not fully ODBC compatible, often, they do support getting data from Access tables. To make this application work with QuickBooks tables, you can run the Microsoft Access setup, as shown above. Then have this application use the MS Access ODBC driver to talk to the Access database you created, which was linked to QuickBooks tables. This middleware approach allows us to support nearly any application, even if not fully ODBC compliant.

 

Also, Refer :
How to Use QODBC with Microsoft Access 2007
Using QuickBooks Data with Access 2013(Import Tables) 32-bit
Using QuickBooks Data with Access 2013 (Linked Tables) 32-bit
How to Configure QODBC to Work With 64-bit MS Access
Microsoft Access 2003 and QODBC

 

Keywords: create odbc connection

(4 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).