[AccessD] Access 2000 to QuickBooks 2004

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Mon Feb 14 09:15:42 CST 2005


Keith:

This would be the code that creates the text files in a format that will 
import into QB using their utility.  That what you're looking for?  Or the 
one-step using the SDK (which I couldn't figure out).

My code exports sales orders which can then be invoiced.

Regards,

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

----- Original Message ----- 
From: "Keith Williamson" <kwilliam at ashlandnet.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Monday, February 14, 2005 6:30 AM
Subject: RE: [AccessD] Access 2000 to QuickBooks 2004


> OOOHHH, OOOHHH...OOOHHHH!!!!  Do you have anything for importing invoice
> detail??
>
> Thanks,
>
> Keith E. Williamson
> Ashland Equipment, Inc
> phone # (410) 273-1856
> fax #     (410) 273-1859
>
>
> -----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
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list