Importing data

[Guest]

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.

 

[Duane Hookom]

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.

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

Thanks for all the help. This gives me a good starting point.

 

[ruralguy via AccessMonster.com]

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]