Keith Williamson
kwilliam at ashlandnet.com
Mon Feb 14 10:29:57 CST 2005
Rocky, I didn't even know that you COULD import sales orders. I've done a lot of importing inventory items...but I didn't know you could import dynamic data, such as sales orders. That is better than not hand entering data, which I am currently doing. I would rather import, with Quickbooks, then directly enter in their tables....I'm not confident that their tables are all that logical. So...yes....the code for creating the text files would be great!! 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: Monday, February 14, 2005 10:16 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2000 to QuickBooks 2004 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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com