Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Sun Feb 13 12:59:53 CST 2005
QBFC - is that new? I didn't see it when I looked into this a couple of years ago, but could have missed it. Do they have an exposed object model? You're right about the import/export though I'm not worried as much about data integrity issues as I am about the awkwardness of it for the user. Regards, Rocky Smolin Beach Access Software http://www.e-z-mrp.com 858-259-4334 ----- Original Message ----- From: "Robert Gracie" <Subscriptions at servicexp.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Sunday, February 13, 2005 10:31 AM Subject: RE: [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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >