[AccessD] Access 2000 to QuickBooks 2004

I have done a couple of export routines from Access to create the format 
QuickBooks likes for import... I have found that my clients prefer this
two-step import-into-QB rather than straight into QB.  They figure that they
have 'more control' as to what they are bringing in...
It was not that hard, but think SimplyAcc was easier ;)

Philip Scyner

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Sent: Sunday, February 13, 2005 8:09 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
>