• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • Last Modified:

I have an access database and I want to synchronise it with quickbooks

I have an access database and I want to synchronise it with quickbooks- how would i even start doing this?

It is a customized database that tracks name, address, postal address, phone number, mobile, email address. I use it to give curtesy calls to clients after a job and email newsletters out. Also I send a gift out to clients after 3 months.
0
chnzchnz
Asked:
chnzchnz
3 Solutions
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can use the QuickBooks SDK:

http://developer.intuit.com/

You must join the Intuit Developer Network in order to gain access to the SDK, but it's free to join. Note that the SDK can be quite difficult to learn.

You can also use some of the 3rd party components. One of the more popular ones is QODBC: http://www.qodbc.com/. It acts as a wrapper for the SDK and allows you to issue SQL-like commands to the Quickbooks database. You cannot directly connect to the Quickbooks database, however - all data access is driven through the SDK.

Note also that Quickbooks does NOT allow you to interact with all portions of the data. As the SDK matures more and more areas of QB are "opened up", but some things you can do in QB just are not available outside of QB. That said, if you're looking to synch customer data (names, phones, etc etc) you should be good to go with either the SDK or QODBC.
0
 
ZillionTechCommented:
What is Quickbooks Connector?
Quickbooks Connector is a fully functional API for reading and writing QuickBooks data files by using standard SQL queries directly to the database.

http://www.quickbooksconnector.com/
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
RE: Quickbooks Connector - I was under the distinct impression that QB didn't allow direct connections, and that the only methods to get to the data was either through the SDK or through Export/Import methods. It seems the folks at that website have some idea they can get to the data, which would be neat but dangerous. I was also under the impression that the data in the Sybase database was encrypted, and that the encryption/decryption routines were not available to the public.

But I could be wrong, as I've never really gotten too far into the subject.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
ZillionTechCommented:
I've heard that the SDK is really slow. Anyone have experience with the SDK?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I've worked with the SDK quite a bit. It is difficult to understand unless you're well versed in OOP techniques, and it can be slow depending on the amount of data you request. Also, not all data is available through the SDK, and you're pretty much at the mercy of QB in regards to what is available. My understanding is that QB provides access ONLY through the SDK so that they can maintain data integrity - that is, you cannot add a Transaction unless you supply an Account, for example.
0
 
stlinaeCommented:
I would suggest just using the the qODBC driver. (It's included with QBES.) You can pull all the QuickBooks data directly into Access and combineit with your current db. If you upgrade to the Read/Write version of th driver you can push some data back into QuickBooks with it. It's the easiest of all the extrnal methods to learn and use, in my opinion.

0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<It's the easiest of all the extrnal methods to learn and use, in my opinion. >

I'd certainly agree with that. The only real drawback is that you must depend on the folks who build QODBC to integrate the new items when they're released by QB; if you work directly with the SDK, you can do that yourself as soon as they come out.
0
 
ZillionTechCommented:
Yes, it looks like the SDK is your best route. But as pointed out earlier, you do not get access to all the data in QB (like payroll)...which might not be a bad thing. It looks like QB Connector allows full access to all data. Also, QB Enterprise is expensive.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can purchase QODBC without purchasing Enterprise. The version of QODBC that ships with Enterprise is a read-only version; you must purchase the full version if you wish to write back to the QB database.

QB Connector doesn't seem to be available at this time - if it is, I couldn't find a download link to it at the website provided. Even so, I'm not sure I'd trust something that hasn't been updated in 6+ months enough to provide it access to my financial data.
0
 
Richard DanekeTrainerCommented:
Yuo can create contacts in outlook and use the synch option in Quickbooks to pull the contacts out of Outlook.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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