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 >