Knowledgebase
[QODBC-Desktop] Microsoft Access 2003 and QODBC
Posted by Rajendra Dewani (QODBC Support) on 12 November 2012 03:43 PM

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.

     Selecting the menu File -> New -> Blank database.

 

     A default database filename db1 appears in the box. You can edit this to a more relevant name, such as QB Link.mdb. Save the file as type "Microsoft Office Access Databases". Click on Create. Here is a Microsoft Office Access blank database.

 

     Click the New button -> Link Table -> OK. (You can also select Import Table option to import the QuickBooks data into Access project but the imported data will not be updated along with it in QuickBooks.)

 

 

     In the popped out window, change the "Files of type" list to the setting for "ODBC Databases".

 

     Then comes up with the 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.)

 

     Select one or more QuickBooks tables to add to your Microsoft Access project and click OK. (Here I add table Customer for example.)

 

     Your QuickBooks tables are now part of your Microsoft Access project as externally linked tables. This does not mean the data in these tables have been imported into Access, but rather that Access will open and work with the live QuickBooks data files, using QODBC to communicate with them.

 

     Double click the table name to bring up the data grid view.

 

     In this grid, you can modify records, delete records and add new records to your QuickBooks table per the table/field accessibility of the QuickBooks. Your QuickBooks files are connected live to your Microsoft Access applications.

Note: In the case where you run across an application which is not fully ODBC compatible, often times 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, which 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 2010 (Import Tables) 32-bit
Using QuickBooks Data with Access 2010(Linked Tables) 32-bit
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

(1 vote(s))
Helpful
Not helpful

Comments (2)
John Merritt
23 September 2014 06:38 PM
QODBC - We have QB Pro 2013 and QB Customer Mgr V2.5. I want to access the Customer Mgr data in Access 2003. Can I do it with QODBC? What is the cost?
Jack
24 September 2014 09:29 AM
Hi John,

QODBC is supporting QuickBooks USA versions 2015-2002, UK or Canadian 2015-2003. QuickBooks Pro, Premiere and Enterprise editions. QODBC is not supporting to QuickBooks customer manager 2.5.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).