Is possible to import data from a other software program like QuickBooks?
Has any one every done this before? I would like to import bank deposit data
so I can run queries on money deposited and money than my database show’s I
collected.

Signature
thank You
Duane Hookom - 01 Nov 2006 18:50 GMT
I'm not familiar with the functionality of QuickBooks but it might allow you
to export records to various formats such as comma separated values or even
XLS. These formats can then be imported into Access.

Signature
Duane Hookom
MS Access MVP
> Is possible to import data from a other software program like QuickBooks?
> Has any one every done this before? I would like to import bank deposit
> data
> so I can run queries on money deposited and money than my database show's
> I
> collected.
BruceS - 01 Nov 2006 19:01 GMT
Gus,
Most commercial accounting packages have data interchange capability,
normally built around a delimited ASCII file format which Access will import.
Typically, comma-separated values (.CSV) is the format.
These programs usually use a proprietary format for the database, so you
can't just connect to it and get what you want. You'll need to use the
"export" feature of the application to create the file, then construct a data
import specification in Access to import it.
Since they're all different, best advice I can give is to create the file
then examine it with Notepad to verify the format and fields.
There also may be some canned routines out there that someone else can point
you to.
HTH,
Bruce
> Is possible to import data from a other software program like QuickBooks?
> Has any one every done this before? I would like to import bank deposit data
> so I can run queries on money deposited and money than my database show’s I
> collected.
Klatuu - 01 Nov 2006 19:04 GMT
Since QuickBooks is a Quicken product, I would suspect it, like Quicken, has
the ability to create a csv formatted file. If this is correct, then you can
export the QuickBooks data and import that. It would also be a good idea to
set up an Import Spec for the file so you get just the data you need in the
correct format.
> Is possible to import data from a other software program like QuickBooks?
> Has any one every done this before? I would like to import bank deposit data
> so I can run queries on money deposited and money than my database show’s I
> collected.
Gus Chuch - 03 Nov 2006 21:34 GMT
Thanks for all the help. This gives me a good starting point.

Signature
thank You
> Since QuickBooks is a Quicken product, I would suspect it, like Quicken, has
> the ability to create a csv formatted file. If this is correct, then you can
[quoted text clipped - 6 lines]
> > so I can run queries on money deposited and money than my database show’s I
> > collected.
ruralguy - 05 Nov 2006 02:14 GMT
Gus,
There is even an SDK that I used a while back to gain access to the QB data.
It was free then.
http://developer.intuit.com/
>Thanks for all the help. This gives me a good starting point.
>> Since QuickBooks is a Quicken product, I would suspect it, like Quicken, has
>> the ability to create a csv formatted file. If this is correct, then you can
>[quoted text clipped - 6 lines]
>> > so I can run queries on money deposited and money than my database show’s I
>> > collected.

Signature
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.