[AccessD] Access 2000 to QuickBooks 2004

Rocky,
 You can use QBFC and VB(A) to communicate directly with QuickBooks Pro.

 I guess the bottom line is that you really should not be using the
Import/Export system in QB, as it can lead to data corruption, because it
completely bypasses QB data & business control logic....

Robert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Sunday, February 13, 2005 11: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
> 

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