[AccessD] Quickbooks

Douglas:

What version of QB are they using?  The later versions allow import and
export via XL or CSV files.

I did write a couple interfaces to QB a few years back and it was a real
PITA. Like you I found the SDK to be impenetrable.

I took a while but I finally found the IIF file layouts and it turned out to
be one of the most Kafkaesque approaches to application interfaces I've ever
seen.  I've still got the formats in a folder but I don't think I can find
the link that described how they're used.  But I can send them to you
offline if you'd like.

But check out the version your client is using first and see if it will
import from XL or CSV.  It will save a lot of aggravation.


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Barnes
Sent: Tuesday, February 24, 2009 8:20 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Quickbooks

Hi group,
I acquired an older database A2K. They want to export data into an iif file
and import that into their QB's. I'm at a loss on how to create the proper
formatting for the task at hand. I've looked at the SDK from Intuit and it
very overwhelming. Does anybody have a template or other ideas on getting
this 'bear' out the door?

thanks

Douglas Barnes

Starn Technical Services
P.O. Box 1172
1057 French Street
Meadville, PA  16335

P: 814.724.1045
F: 814.337.3460

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com