Access to Quickbooks

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

re: Access to Quickbooks

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.

re: Access to Quickbooks

penguin732901@aol.com wrote in
news:1136311760.531203.208800@o13g2000cwo.googlegr oups.com:
[color=blue]
> 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...)[/color]

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/

re: Access to Quickbooks

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

re: Access to Quickbooks

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.
resource@pcdatasheet.com





<penguin732901@aol.com> wrote in message
news:1136475667.665421.30070@f14g2000cwb.googlegro ups.com...[color=blue]
> 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...)
>[/color]

re: Access to Quickbooks

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" <nospam@nospam.spam> wrote in message
news:4dhvf.3223$%W1.1494@newsread2.news.atl.earthl ink.net...[color=blue]
> 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[/color]
help.[color=blue]
> resource@pcdatasheet.com
>
>
>
>
>
> <penguin732901@aol.com> wrote in message
> news:1136475667.665421.30070@f14g2000cwb.googlegro ups.com...[color=green]
> > 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...)
> >[/color]
>
>[/color]

re: Access to Quickbooks

Rob Oldfield wrote:
[color=blue]
> 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[/color]

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.

re: Access to Quickbooks

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

re: Access to Quickbooks

penguin732901@aol.com wrote:[color=blue]
> 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...)
>[/color]
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

re: Access to Quickbooks

"salad" <oil@vinegar.com> wrote in message
news:WUlvf.3613$Hl6.1437@newsread3.news.pas.earthl ink.net...[color=blue]
> Rob Oldfield wrote:
>[color=green]
> > 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[/color][/color]
sell[color=blue][color=green]
> > his services.
> >
> >
> > Before you intend to do business with him look at:
> > http://home.tiscali.nl/arracom/whoissteve.html[/color]
>
> 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[/color]
asked.[color=blue]
>
> Sometimes I feel like I'm attending a kindergarten class tho I was
> sheduled for an adult class.
>[/color]

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.

re: Access to Quickbooks

"Rob Oldfield" <blah@blah.com> schreef in bericht news:43bec568$0$907$db0fefd9@news.zen.co.uk...[color=blue]
>
> 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.[/color]

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

re: Access to Quickbooks

"Arno R" <arraNOcomSPAM@tiscali.nl> wrote in message
news:43bed0cb$0$10088$ba620dc5@text.nova.planet.nl ...

"Rob Oldfield" <blah@blah.com> schreef in bericht
news:43bec568$0$907$db0fefd9@news.zen.co.uk...[color=blue]
>
> 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.[/color]

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'?

re: Access to Quickbooks

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.

re: Access to Quickbooks

Jana wrote:[color=blue]
>To see the full email address, click on the hyperlinked >portion of the poster's email address.[/color]
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.

re: Access to Quickbooks

Jana wrote:[color=blue]
>To see the full email address, click on the hyperlinked >portion of the poster's email address.[/color]
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.

re: Access to Quickbooks

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

re: Access to Quickbooks

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

re: Access to Quickbooks

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

<penguin732901@aol.com> wrote in message
news:1136311760.531203.208800@o13g2000cwo.googlegr oups.com...[color=blue]
>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...)
>[/color]

re: Access to Quickbooks

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 ***

re: Access to Quickbooks

Larry,

What is the API you are referring to?

TC

"Larry Linson" <bouncer@localhost.not> wrote:
[color=blue]
>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
>
><penguin732901@aol.com> wrote in message
>news:1136311760.531203.208800@o13g2000cwo.googleg roups.com...[color=green]
>>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...)
>>[/color]
>
>[/color]