Integrating with Quickbooks

[Jimmy]

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?

[Jimmy]

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?

[Jimmy]

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?

[Bob Alston]

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

[Larry Linson]

"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

[Jimmy]

"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.

[Larry Linson]

"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