[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 629
  • 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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