Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 628
  • Last Modified:

Help getting started with ODBC connection to Quickbooks from Access

I'm getting pretty good with MS Access, to the point where I'm using it with some financial modeling and performance measurement.  My company uses Quickbooks (Pro 2008) and doesn't appear to have the ODBC Utility/Driver installed.  

I'd like to be able to connect to the data in Quickbooks from Access, but am not sure where to start.  Can anyone provide some starting points?
0
BBlu
Asked:
BBlu
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can purchase 3rd party products like QODBC (www.qodbc.com) which allow you to interact with Quickbooks. Or, you can use the SDK to connect with and interact with QB. The SDK can be quite daunting and difficult to learn, especially if you're not well versed in OOP protocols. Note also that not all portions of QB are available, regardless of what access method you use.

Also, the drivers (like QODBC) are simply wrappers around the SDK - they're not true ODBC drivers.
0
 
BBluAuthor Commented:
Thanks, LSMConsulting.  I've downloaded the trial version and will try to figure it out.
0
 
BBluAuthor Commented:
Thanks, LSM Consulting
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now