By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,106 Members | 2,474 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,106 IT Pros & Developers. It's quick & easy.

Integrating with Quickbooks

P: n/a
I am developing a project management database for my company and would like
to somehow integrate or share data from my quickbooks file. I am currently
using Access 2003 and Quickbooks 2003 Pro.

In my access database I have a much more in depth customer database but
would like to eliminate the need to enter new customers and addresses twice,
once in qb and once in the access db. I would also like to be able to read
from the items list in qb. I would not necessarily need to alter the info in
qb but rather read from it from combo boxes in my access forms.

I have read a little bit about a product called OfficeQ from Datablox but am
unsure if this will help and they do not currenlty offer a trial software to
experiment with.

Does anyone here have any experience using this product or have some other
suggestions that I might consider?
Jan 5 '07 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Bump...

"Jimmy" <do**@email.mewrote in message
news:J5********************@fe04.news.easynews.com ...
>I am developing a project management database for my company and would like
to somehow integrate or share data from my quickbooks file. I am currently
using Access 2003 and Quickbooks 2003 Pro.

In my access database I have a much more in depth customer database but
would like to eliminate the need to enter new customers and addresses
twice, once in qb and once in the access db. I would also like to be able
to read from the items list in qb. I would not necessarily need to alter
the info in qb but rather read from it from combo boxes in my access
forms.

I have read a little bit about a product called OfficeQ from Datablox but
am unsure if this will help and they do not currenlty offer a trial
software to experiment with.

Does anyone here have any experience using this product or have some other
suggestions that I might consider?

Jan 6 '07 #2

P: n/a
Nobody?

"Jimmy" <do**@email.mewrote in message
news:Ic*********************@fe09.news.easynews.co m...
Bump...

"Jimmy" <do**@email.mewrote in message
news:J5********************@fe04.news.easynews.com ...
>>I am developing a project management database for my company and would
like to somehow integrate or share data from my quickbooks file. I am
currently using Access 2003 and Quickbooks 2003 Pro.

In my access database I have a much more in depth customer database but
would like to eliminate the need to enter new customers and addresses
twice, once in qb and once in the access db. I would also like to be able
to read from the items list in qb. I would not necessarily need to alter
the info in qb but rather read from it from combo boxes in my access
forms.

I have read a little bit about a product called OfficeQ from Datablox but
am unsure if this will help and they do not currenlty offer a trial
software to experiment with.

Does anyone here have any experience using this product or have some
other suggestions that I might consider?


Jan 7 '07 #3

P: n/a
Jimmy wrote:
Nobody?

"Jimmy" <do**@email.mewrote in message
news:Ic*********************@fe09.news.easynews.co m...
>Bump...

"Jimmy" <do**@email.mewrote in message
news:J5********************@fe04.news.easynews.co m...
>>I am developing a project management database for my company and would
like to somehow integrate or share data from my quickbooks file. I am
currently using Access 2003 and Quickbooks 2003 Pro.

In my access database I have a much more in depth customer database but
would like to eliminate the need to enter new customers and addresses
twice, once in qb and once in the access db. I would also like to be able
to read from the items list in qb. I would not necessarily need to alter
the info in qb but rather read from it from combo boxes in my access
forms.

I have read a little bit about a product called OfficeQ from Datablox but
am unsure if this will help and they do not currenlty offer a trial
software to experiment with.

Does anyone here have any experience using this product or have some
other suggestions that I might consider?

Some of these links might be of interest:

http://webpages.charter.net/bobalsto...n-Software.htm

Bob
Jan 7 '07 #4

P: n/a
"Jimmy" wrote
Nobody?
Patience, I am told, is a virtue, Jimmy. When I am pressed for time, I only
click through to posts that seem appropriate for me to answer quickly, and,
in any case, QuickBooks is not a subject on which I have deep knowledge.
Today, however, I have a little more time.

I do know, however, there is a third-party product called QODBC. Once when I
thought I was going to be working on a contract interfacing Access and
QuickBooks, I downloaded the free trial, and had no trouble establishing a
connection between Access and a QuickBooks database. The contract didn't
come about, so that was the extent of my involvement.

I noted also, that the QODBC web site appeared to have very complete
descriptions of the tables and fields in QuickBooks. The URL is
http://www.qodbc.com/. Not having "fired QODBC in anger", I can't comment on
its quality, performance, or usability, only on its existence and the ease
of connecting to an existing QuickBooks database.

Larry Linson
Microsoft Access MVP


Jan 7 '07 #5

P: n/a

"Larry Linson" <bo*****@localhost.notwrote in message
news:eXcoh.5083$rz3.2109@trnddc03...
Patience, I am told, is a virtue, Jimmy.
I have been told this before! Never gave it much thought however.
I do know, however, there is a third-party product called QODBC.
Yes, another poster also suggested this (Bob Alston). I checked out their
website this afternoon and downloaded the trial program to play around with.
I seems that this will do the trick and if it works as well as they say and
does as I suspect it might, it will be well worth the purchase price.

Again, pardon my impatience, and thanks for the advice.

Jan 8 '07 #6

P: n/a
"Jimmy" wrote
Again, pardon my impatience, and thanks for the advice.
That was just a gratuitous comment in re: patience. No big deal.

You are welcome. Oh, I seem to have left the impression that I only
"connected" but I did experiement and was able to retrieve, update, and add
records. As I like to be thorough, I am reasonably sure I also tried
deleting.

Larry Linson
Microsoft Access MVP
Jan 8 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.