[AccessD] Access 2000 to QuickBooks 2004

Joe:

I've written a couple of export routines from Access to create the format 
the QuickBooks likes for import.  It was a real PITA.  But I've got the code 
if you want it.  It will get you started, give you the template.  But it's 
the two-step approach export-import.  The direct insertion of Access data 
into QuickBooks involved their SDK and C.  So I didn't even look at that.

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
858-259-4334

----- Original Message ----- 
From: "Joe Rojas" <JRojas at tnco-inc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, February 11, 2005 9:18 AM
Subject: [AccessD] Access 2000 to QuickBooks 2004


> Hi All,
>
> I created an expense reporting database with Access 2000.
> I am trying to import this data to QuickBooks 2004 so that when we 
> download
> our transactions from American Express to QuickBooks the expenses are
> already recorded and are ready to be reconciled.
>
> Does anyone have experience on getting data from Access to QuickBooks?
>
> Thanks!
>
> JR
>
>
>
>
> This electronic transmission is strictly confidential to TNCO, Inc. and
> intended solely for the addressee. It may contain information which is
> covered by legal, professional, or other privileges. If you are not the
> intended addressee, or someone authorized by the intended addressee to
> receive transmissions on behalf of the addressee, you must not retain,
> disclose in any form, copy, or take any action in reliance on this
> transmission. If you have received this transmission in error, please 
> notify
> the sender as soon as possible and destroy this message. While TNCO, Inc.
> uses virus protection, the recipient should check this email and any
> attachments for the presence of viruses. TNCO, Inc. accepts no liability 
> for
> any damage caused by any virus transmitted by this email.
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>