MartyConnelly
martyconnelly at shaw.ca
Sun May 30 13:14:43 CDT 2004
While looking for something else came across these two methods for getting data from Quickbooks. One is an ODBC driver for QB reports and tables (careful they sell a read and and read write driver) ; other is ActiveX control that handles QBxml QODBC is a fully functional ODBC driver for reading and writing QuickBooks 2002, 2003 and 2004 accounting data files by using standard SQL queries. Handles reports and tables 30 day trial evaluation. 200 - 500 dollars pc and server. Can use from Excel or Access; from Flexquarters software http://qodbc.com/link2.mgi?source=google&search=api http://www.qodbc.com/qodbcfaq.htm AcctSync SDK ActiveX / VB Edition Version 2.0 Small, fast, easy-to-use, and fully self-contained ActiveX Controls built with ATL. No dependencies on any external libraries. Ideal for use with any COM container, from Visual Basic, to Internet Explorer, Office/VBA, etc. Uses QBxml. Can use from MS Office, Java Win CE, .Net and C++ @ $300 http://www.acctsync.com/acctsync/products/showprod.aspx?part=ACA2-A Might be usefuol with ActSync Messenger for 3d'party customer data connections through a website http://www.acctsync.com/acctsync/products/messenger/ Robert Gracie wrote: >Maryty, > Sounds Interesting, any examples? > > >Robert Gracie >www.servicexp.com > > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MartyConnelly >Sent: Wednesday, May 26, 2004 2:13 PM >To: Access Developers discussion and problem solving >Subject: Re: [AccessD] Quickbook Question. > > >Aren't you using the QBXML method to pass data back and forth?. It only >works for Canadian and US versions >You just use an XML DOM to parse and massage the data back and forth, >although their examples are so twentieth century using child elements >instead of XPATH methods which require a lot less code. >https://developer.intuit.com/Support/FAQs/?id=144#faq_qbsdk_q5 > >Robert Gracie wrote: > > > >>Rocky, >> Yep, I had the same opinion, and I think the 2 step process is what I >> >> >will > > >>end up with.. Your examples would be much appreciated, Thanks!!!! >> >>robert at servicexp.com >> >>Robert Gracie >>www.servicexp.com >> >> >>-----Original Message----- >>From: accessd-bounces at databaseadvisors.com >>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin - >>Beach Access Software >>Sent: Tuesday, May 25, 2004 10:56 PM >>To: Access Developers discussion and problem solving >>Subject: Re: [AccessD] Quickbook Question. >> >> >>Robert: >> >>I looked at the SDK and gave up right away. I don't do C. >> >>I used the two step approach of exporting from my app and then importing >>that file into QuickBooks through their Import Utility. >> >>Formatting the output file to their specification was about as convoluted a >>process as I've ever seen. But I got there eventually. >> >>There is a web site where they've got some examples and I can send you my >>code off line if you decide to do the two step. >> >>I wish they did have an easy way to push stuff straight into their system, >>but they don't. >> >>Rocky Smolin >>Beach Access Software >>http://www.e-z-mrp.com >> >>----- Original Message ----- >>From: "Robert Gracie" <Subscriptions at servicexp.com> >>To: "Access Developers discussion and problem solving" >><accessd at databaseadvisors.com> >>Sent: Tuesday, May 25, 2004 6:05 PM >>Subject: [AccessD] Quickbook Question. >> >> >> >> >> >> >>>Has anyone had any success communicating directly with QBPro? I purchased >>>the CoreObjX20.dll but it has proven to be fairly useless, very difficult >>> >>> >>> >>> >>to >> >> >> >> >>>even get the .dll set up and registered... >>> >>>Any idea's or help would be great! >>> >>>Thanks!! >>>Robert Gracie >>>www.servicexp.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 >> >> >> >> >> >> > >-- >Marty Connelly >Victoria, B.C. >Canada > > > >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > > > > -- Marty Connelly Victoria, B.C. Canada