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

Access to Quickbooks

P: n/a
I need to export my Access data to Quickbooks to make my accountant
happy.

A google search netted me one product for $399 at
http://www.atandra.com/Prod_DFM.htm. I'd like to know if anyone has
any other suggestions (other than spending a lot of time exporting my
customers, vendors etc and, from what I understand, entering
transactions individually...)

Jan 3 '06 #1
Share this Question
Share on Google+
19 Replies


P: n/a
Red
It's been a WHILE since I used quickbooks (6-7 years), but can't you
import information from Excel into quickbooks?

And if so, then you can easily export spreadsheets from Access, then
import those spreadsheet into QB's.

Jan 3 '06 #2

P: n/a
pe***********@aol.com wrote in
news:11**********************@o13g2000cwo.googlegr oups.com:
I need to export my Access data to Quickbooks to make my
accountant happy.

A google search netted me one product for $399 at
http://www.atandra.com/Prod_DFM.htm. I'd like to know if anyone
has any other suggestions (other than spending a lot of time
exporting my customers, vendors etc and, from what I understand,
entering transactions individually...)


If I'm not mistaken, QB used to provide an ODBC driver. But maybe
I'm confusing that with MYOB, which definitely does provide an ODBC
driver. Maybe QB provided a COM automation interface. Whichever,
there was a method for shipping data back and forth that didn't
require writing the horrid QIF files.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jan 3 '06 #3

P: n/a
Quickbooks offers a Software Developer's Kit. It seems to be able to
read QB in Access format. I've emailed to ask about the reverse.

Then I got a demo of QODBC, same problem.

Yes, you can export lists from Access to Excel, & read them into QB
(after first figuring out the table layout, of course) but it seems
this will only work for customers, vendors etc.

The transactions are not in a simple table format, but something like
begin transaction
do some stuff
end transaction.

I KNOW there are folks out there who have done this. If only I could
find them!
(BTW, does anyone know a current email address for someone named Terry
Zinno? She posted some time back about this topic.

For that matter, can you tell me how to find an email address in a
Google groups posting? It seems to truncate people's emails...)

Jan 5 '06 #4

P: n/a
Try these sites:

http://marketplace.intuit.com/search.asp?category=211

http://www.qodbc.com/qodbcaccess.htm

www.datablox.com
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1075 users have come from the newsgroups requesting help.
re******@pcdatasheet.com

<pe***********@aol.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Quickbooks offers a Software Developer's Kit. It seems to be able to
read QB in Access format. I've emailed to ask about the reverse.

Then I got a demo of QODBC, same problem.

Yes, you can export lists from Access to Excel, & read them into QB
(after first figuring out the table layout, of course) but it seems
this will only work for customers, vendors etc.

The transactions are not in a simple table format, but something like
begin transaction
do some stuff
end transaction.

I KNOW there are folks out there who have done this. If only I could
find them!
(BTW, does anyone know a current email address for someone named Terry
Zinno? She posted some time back about this topic.

For that matter, can you tell me how to find an email address in a
Google groups posting? It seems to truncate people's emails...)

Jan 5 '06 #5

P: n/a
To quote Arno:

Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell
his services.
Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

"PC Datasheet" <no****@nospam.spam> wrote in message
news:4d*****************@newsread2.news.atl.earthl ink.net...
Try these sites:

http://marketplace.intuit.com/search.asp?category=211

http://www.qodbc.com/qodbcaccess.htm

www.datablox.com
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1075 users have come from the newsgroups requesting help. re******@pcdatasheet.com

<pe***********@aol.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Quickbooks offers a Software Developer's Kit. It seems to be able to
read QB in Access format. I've emailed to ask about the reverse.

Then I got a demo of QODBC, same problem.

Yes, you can export lists from Access to Excel, & read them into QB
(after first figuring out the table layout, of course) but it seems
this will only work for customers, vendors etc.

The transactions are not in a simple table format, but something like
begin transaction
do some stuff
end transaction.

I KNOW there are folks out there who have done this. If only I could
find them!
(BTW, does anyone know a current email address for someone named Terry
Zinno? She posted some time back about this topic.

For that matter, can you tell me how to find an email address in a
Google groups posting? It seems to truncate people's emails...)


Jan 6 '06 #6

P: n/a
Rob Oldfield wrote:
To quote Arno:

Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell
his services.
Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html


I didn't see a problem with the links PC Datasheet provided. Did you?
It seemed to provide solutions or alternatives to the question the OP asked.

Sometimes I feel like I'm attending a kindergarten class tho I was
sheduled for an adult class.

Jan 6 '06 #7

P: n/a
To see the full email address, click on the hyperlinked portion of the
poster's email address. Google will take you to a page to confirm
you're not automating to cull email addresses.

Jana

Jan 6 '06 #8

P: n/a
pe***********@aol.com wrote:
I need to export my Access data to Quickbooks to make my accountant
happy.

A google search netted me one product for $399 at
http://www.atandra.com/Prod_DFM.htm. I'd like to know if anyone has
any other suggestions (other than spending a lot of time exporting my
customers, vendors etc and, from what I understand, entering
transactions individually...)

Take a look at my web site with lists of several ODBC drivers, data
extraction software and email software allowing interaction with
quickbooks. The info on my web site is FREE. The items listed may or
may not have a fee.

http://members.cox.net/tulsaalstons/...n-Software.htm

Bob
Jan 6 '06 #9

P: n/a
"salad" <oi*@vinegar.com> wrote in message
news:WU*****************@newsread3.news.pas.earthl ink.net...
Rob Oldfield wrote:
To quote Arno:

Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.
Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html
I didn't see a problem with the links PC Datasheet provided. Did you?
It seemed to provide solutions or alternatives to the question the OP

asked.
Sometimes I feel like I'm attending a kindergarten class tho I was
sheduled for an adult class.


No. I don't see any problem at all with it. I'd hope that the pressure
applied to him has made him change his ways but, a couple of 'good' posts
don't convince me.

And if he has indeed finally got the idea, then why would you say that is?
And what did you do to help? If the answer to that is 'nothing' then I
really don't think you're in a position to patronise anyone.

Still, it's good to see that Steve can still spark arguments.
Jan 6 '06 #10

P: n/a

"Rob Oldfield" <bl**@blah.com> schreef in bericht news:43*********************@news.zen.co.uk...

No. I don't see any problem at all with it. I'd hope that the pressure
applied to him has made him change his ways but, a couple of 'good' posts
don't convince me.

And if he has indeed finally got the idea, then why would you say that is?
And what did you do to help? If the answer to that is 'nothing' then I
really don't think you're in a position to patronise anyone.

Still, it's good to see that Steve can still spark arguments.


Hi Rob,
Well, I really thought your reply was about (or because of) the siglines ....
I did not answer here because I am trying very hard to stick to 'one reply to Steve per thread'.

But: where I live a sig like Steve's is still called jobhunting.
Some minor changes indeed, but I don't see that much 'compromise' effort yet ...
He only left out the 'trusting me' for whatever reason, and increased his number of 'requesting users'.
The figure of xxxx users is only a proof (or confirmation) of his blatant advertising ...
So I don't consider this one a 'good' post, but if you do it is allright with me.
(Well in fact it is a 'good' post, but a 'bad' sig ...)

We have had several 'discussions' with Steve about siglines in the past.
I don't feel like starting a new discussion about this.
It is obvious to me. Maybe it's about time Steve stops playing games?

Arno R
Jan 6 '06 #11

P: n/a
"Arno R" <ar***********@tiscali.nl> wrote in message
news:43***********************@text.nova.planet.nl ...

"Rob Oldfield" <bl**@blah.com> schreef in bericht
news:43*********************@news.zen.co.uk...

No. I don't see any problem at all with it. I'd hope that the pressure
applied to him has made him change his ways but, a couple of 'good' posts
don't convince me.

And if he has indeed finally got the idea, then why would you say that is?
And what did you do to help? If the answer to that is 'nothing' then I
really don't think you're in a position to patronise anyone.

Still, it's good to see that Steve can still spark arguments.


Hi Rob,
Well, I really thought your reply was about (or because of) the siglines ...
I did not answer here because I am trying very hard to stick to 'one reply
to Steve per thread'.

But: where I live a sig like Steve's is still called jobhunting.
Some minor changes indeed, but I don't see that much 'compromise' effort yet
....
He only left out the 'trusting me' for whatever reason, and increased his
number of 'requesting users'.
The figure of xxxx users is only a proof (or confirmation) of his blatant
advertising ...
So I don't consider this one a 'good' post, but if you do it is allright
with me.
(Well in fact it is a 'good' post, but a 'bad' sig ...)

We have had several 'discussions' with Steve about siglines in the past.
I don't feel like starting a new discussion about this.
It is obvious to me. Maybe it's about time Steve stops playing games?

Arno R
____________

To be honest, I hadn't really thought it through, even after salad's little
dig. Can I change my 'good' to 'better'?


Jan 6 '06 #12

P: n/a
Thanks, Bob. I've downloaded the demo for Synergration's developer
edition. It looks like the most user-friendly one so far, and I think
it will serve my purpose.

Jan 9 '06 #13

P: n/a
Jana wrote:
To see the full email address, click on the hyperlinked >portion of the poster's email address.

But, that's exactly what I don't see.

When I click Options, I see your name as
Jana" <Bauer.J...@gmail.com> Which doesn't get me too far.

Jan 9 '06 #14

P: n/a
Jana wrote:
To see the full email address, click on the hyperlinked >portion of the poster's email address.

But, that's exactly what I don't see.

When I click Options, I see your name as
Jana" <Bauer.J...@gmail.com> Which doesn't get me too far.

Jan 9 '06 #15

P: n/a
>To see the full email address, click on the hyperlinked >portion of the poster's email address.
But, that's exactly what I don't see.

When I click Options, I see your name as
Jana" <Bauer.J...@gmail.com> Which doesn't get me too far.

Jan 9 '06 #16

P: n/a
>To see the full email address, click on the hyperlinked >portion of the poster's email address.

That's exactly what I don't see from my google groups reader.

When I click on Options, I see your address, for example, as "Jana"
<Bauer.J...@gmail.com>, which would not get me too far....

Jan 9 '06 #17

P: n/a
There is a product called QODBC which provides ODBC access to QuickBooks
tables. You can download a trial version to see if it suits your needs. I am
just now trying it, so won't recommend either for or against it.

There is also an API (application programming interface). One of my
colleagues who's used it strongly advised using QODBC "if it is any good at
all".

Larry Linson
Microsoft Access MVP

<pe***********@aol.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I need to export my Access data to Quickbooks to make my accountant
happy.

A google search netted me one product for $399 at
http://www.atandra.com/Prod_DFM.htm. I'd like to know if anyone has
any other suggestions (other than spending a lot of time exporting my
customers, vendors etc and, from what I understand, entering
transactions individually...)


Jan 9 '06 #18

P: n/a

Liahona Development Solutions has a product called EzRouter that
connects directly to Quickbooks via Excel, ACCESS, CSV, or ODBC. It's
quick and easy!

You can reach them at 800-687-1587.
or
www.ldscorp.org
*** Sent via Developersdex http://www.developersdex.com ***
Jan 10 '06 #19

P: n/a
Larry,

What is the API you are referring to?

TC

"Larry Linson" <bo*****@localhost.not> wrote:
There is a product called QODBC which provides ODBC access to QuickBooks
tables. You can download a trial version to see if it suits your needs. I am
just now trying it, so won't recommend either for or against it.

There is also an API (application programming interface). One of my
colleagues who's used it strongly advised using QODBC "if it is any good at
all".

Larry Linson
Microsoft Access MVP

<pe***********@aol.com> wrote in message
news:11**********************@o13g2000cwo.googleg roups.com...
I need to export my Access data to Quickbooks to make my accountant
happy.

A google search netted me one product for $399 at
http://www.atandra.com/Prod_DFM.htm. I'd like to know if anyone has
any other suggestions (other than spending a lot of time exporting my
customers, vendors etc and, from what I understand, entering
transactions individually...)



Jan 14 '06 #20

This discussion thread is closed

Replies have been disabled for this discussion.