Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #13008 > unrolled thread
| Started by | PW <PW@noemailaddress.com> |
|---|---|
| First post | 2018-03-13 14:29 -0600 |
| Last post | 2018-03-15 11:10 -0600 |
| Articles | 8 — 3 participants |
Back to article view | Back to comp.databases.ms-access
Importing data to Quickbooks PW <PW@noemailaddress.com> - 2018-03-13 14:29 -0600
Re: Importing data to Quickbooks Ulrich Möller <knobbi38@arcor.de> - 2018-03-13 23:16 +0100
Re: Importing data to Quickbooks PW <PW@noemailaddress.com> - 2018-03-14 10:39 -0600
Re: Importing data to Quickbooks PW <PW@noemailaddress.com> - 2018-03-14 10:42 -0600
Re: Importing data to Quickbooks Ron Paii <ron81pai@gmail.com> - 2018-03-15 05:11 -0700
Re: Importing data to Quickbooks PW <PW@noemailaddress.com> - 2018-03-15 11:10 -0600
Re: Importing data to Quickbooks Ulrich Möller <knobbi38@arcor.de> - 2018-03-15 15:47 +0100
Re: Importing data to Quickbooks PW <PW@noemailaddress.com> - 2018-03-15 11:10 -0600
| From | PW <PW@noemailaddress.com> |
|---|---|
| Date | 2018-03-13 14:29 -0600 |
| Subject | Importing data to Quickbooks |
| Message-ID | <g3dgaddtjvanbn6f3boi8k9po131h7mu5q@4ax.com> |
Has anyone done this successfully from Access? Our software only tracks income. Thanks! -paulw
[toc] | [next] | [standalone]
| From | Ulrich Möller <knobbi38@arcor.de> |
|---|---|
| Date | 2018-03-13 23:16 +0100 |
| Message-ID | <p89ika$4v3$1@dont-email.me> |
| In reply to | #13008 |
Hi PW, Am 13.03.2018 um 21:29 schrieb PW: > Has anyone done this successfully from Access? > > Our software only tracks income. I have no experience with QB but i have seen odbc drivers and/or intuit provides a SDK for downloading. Some additional information can be found here: https://pulseinfomatics.com/microsoft-access-quickbooks-sdk-part-1/ https://it.toolbox.com/blogs/matthewmoran/connect-microsoft-access-to-quickbooks-090815 Ulrich
[toc] | [prev] | [next] | [standalone]
| From | PW <PW@noemailaddress.com> |
|---|---|
| Date | 2018-03-14 10:39 -0600 |
| Message-ID | <50kiadhp7hnjeq5i2mh3obv3d7j1jvf7g6@4ax.com> |
| In reply to | #13010 |
On Tue, 13 Mar 2018 23:16:47 +0100, Ulrich Möller <knobbi38@arcor.de> wrote: >Hi PW, > >Am 13.03.2018 um 21:29 schrieb PW: >> Has anyone done this successfully from Access? >> >> Our software only tracks income. >I have no experience with QB but i have seen odbc drivers and/or intuit >provides a SDK for downloading. >Some additional information can be found here: >https://pulseinfomatics.com/microsoft-access-quickbooks-sdk-part-1/ >https://it.toolbox.com/blogs/matthewmoran/connect-microsoft-access-to-quickbooks-090815 > >Ulrich > *--- Thanks! I will check those out. I remember getting frustrated years ago when I tried to sync access with QB. And the SDKs were confusing to me. I am worried about messing up clients QB data! -paulw
[toc] | [prev] | [next] | [standalone]
| From | PW <PW@noemailaddress.com> |
|---|---|
| Date | 2018-03-14 10:42 -0600 |
| Message-ID | <35kiadhie9ca8940tpb7e4f585bfelfcbl@4ax.com> |
| In reply to | #13010 |
On Tue, 13 Mar 2018 23:16:47 +0100, Ulrich Möller <knobbi38@arcor.de> wrote: >Hi PW, > >Am 13.03.2018 um 21:29 schrieb PW: >> Has anyone done this successfully from Access? >> >> Our software only tracks income. >I have no experience with QB but i have seen odbc drivers and/or intuit >provides a SDK for downloading. >Some additional information can be found here: >https://pulseinfomatics.com/microsoft-access-quickbooks-sdk-part-1/ >https://it.toolbox.com/blogs/matthewmoran/connect-microsoft-access-to-quickbooks-090815 > >Ulrich > *--- Now I remember why I got frustrated. Everything I found went from QB to Access. That is not what I want to do! I want to go from Access to QB. -paulw
[toc] | [prev] | [next] | [standalone]
| From | Ron Paii <ron81pai@gmail.com> |
|---|---|
| Date | 2018-03-15 05:11 -0700 |
| Message-ID | <17c428b1-183b-4697-9851-02383d7ebe15@googlegroups.com> |
| In reply to | #13014 |
On Wednesday, March 14, 2018 at 11:42:12 AM UTC-5, PW wrote: > On Tue, 13 Mar 2018 23:16:47 +0100, Ulrich Möller <knobbi38@arcor.de> > wrote: > > >Hi PW, > > > >Am 13.03.2018 um 21:29 schrieb PW: > >> Has anyone done this successfully from Access? > >> > >> Our software only tracks income. > >I have no experience with QB but i have seen odbc drivers and/or intuit > >provides a SDK for downloading. > >Some additional information can be found here: > >https://pulseinfomatics.com/microsoft-access-quickbooks-sdk-part-1/ > >https://it.toolbox.com/blogs/matthewmoran/connect-microsoft-access-to-quickbooks-090815 > > > >Ulrich > > > > > *--- > > Now I remember why I got frustrated. Everything I found went from QB > to Access. That is not what I want to do! I want to go from Access > to QB. > > -paulw I doubt any commercial accounting package would allow write access though linked tables or queries. If they use a SQL server, you may be able to setup a connection and force a write; which would likely corrupt the data and void any support. Some API calls may allow updates similar to how the application's forms operate. Some will allow importing of data and allow you to trigger imports from your application.
[toc] | [prev] | [next] | [standalone]
| From | PW <PW@noemailaddress.com> |
|---|---|
| Date | 2018-03-15 11:10 -0600 |
| Message-ID | <90alad9pua821r7s6fk9vj00qd5m9k25pu@4ax.com> |
| In reply to | #13015 |
On Thu, 15 Mar 2018 05:11:10 -0700 (PDT), Ron Paii <ron81pai@gmail.com> wrote: >On Wednesday, March 14, 2018 at 11:42:12 AM UTC-5, PW wrote: >> On Tue, 13 Mar 2018 23:16:47 +0100, Ulrich Möller <knobbi38@arcor.de> >> wrote: >> >> >Hi PW, >> > >> >Am 13.03.2018 um 21:29 schrieb PW: >> >> Has anyone done this successfully from Access? >> >> >> >> Our software only tracks income. >> >I have no experience with QB but i have seen odbc drivers and/or intuit >> >provides a SDK for downloading. >> >Some additional information can be found here: >> >https://pulseinfomatics.com/microsoft-access-quickbooks-sdk-part-1/ >> >https://it.toolbox.com/blogs/matthewmoran/connect-microsoft-access-to-quickbooks-090815 >> > >> >Ulrich >> > >> >> >> *--- >> >> Now I remember why I got frustrated. Everything I found went from QB >> to Access. That is not what I want to do! I want to go from Access >> to QB. >> >> -paulw > >I doubt any commercial accounting package would allow write access though linked tables or queries. If they use a SQL server, you may be able to setup a connection and force a write; which would likely corrupt the data and void any support. Some API calls may allow updates similar to how the application's forms operate. Some will allow importing of data and allow you to trigger imports from your application. *-- That may also have been a concern of mine. My wife and my software has a report with Quickbooks information that only takes a few minutes to manually type into QB. At most. I am sick of being asked if our software interfaces with Quickbooks! It isn't like these lodges are doing the business like "Amazon" does! Thank you. -paul
[toc] | [prev] | [next] | [standalone]
| From | Ulrich Möller <knobbi38@arcor.de> |
|---|---|
| Date | 2018-03-15 15:47 +0100 |
| Message-ID | <p8e11q$5l1$1@dont-email.me> |
| In reply to | #13014 |
Am 14.03.2018 um 17:42 schrieb PW: > On Tue, 13 Mar 2018 23:16:47 +0100, Ulrich Möller<knobbi38@arcor.de> > wrote: > Am 13.03.2018 um 21:29 schrieb PW: >> Has anyone done this successfully from Access? >> >> Our software only tracks income. > I have no experience with QB but i have seen odbc drivers and/or intuit > provides a SDK for downloading. > Some additional information can be found here: > https://pulseinfomatics.com/microsoft-access-quickbooks-sdk-part-1/ > https://it.toolbox.com/blogs/matthewmoran/connect-microsoft-access-to-quickbooks-090815 > *--- > > Now I remember why I got frustrated. Everything I found went from QB > to Access. That is not what I want to do! I want to go from Access > to QB. Take a look at the sdk samples. There are some how show you how to add/modify customers or invoices in QB. Sure not in vba but in other programming languages. There are also some QDBC drivers which will allow write access to QB. Maybe it will help a little bit. Ulrich
[toc] | [prev] | [next] | [standalone]
| From | PW <PW@noemailaddress.com> |
|---|---|
| Date | 2018-03-15 11:10 -0600 |
| Message-ID | <f8aladt762hdo55342s383l8biplcuc24q@4ax.com> |
| In reply to | #13017 |
On Thu, 15 Mar 2018 15:47:22 +0100, Ulrich Möller <knobbi38@arcor.de> wrote: >Am 14.03.2018 um 17:42 schrieb PW: >> On Tue, 13 Mar 2018 23:16:47 +0100, Ulrich Möller<knobbi38@arcor.de> >> wrote: >> Am 13.03.2018 um 21:29 schrieb PW: >>> Has anyone done this successfully from Access? >>> >>> Our software only tracks income. >> I have no experience with QB but i have seen odbc drivers and/or intuit >> provides a SDK for downloading. >> Some additional information can be found here: >> https://pulseinfomatics.com/microsoft-access-quickbooks-sdk-part-1/ >> https://it.toolbox.com/blogs/matthewmoran/connect-microsoft-access-to-quickbooks-090815 >> *--- >> >> Now I remember why I got frustrated. Everything I found went from QB >> to Access. That is not what I want to do! I want to go from Access >> to QB. >Take a look at the sdk samples. There are some how show you how to >add/modify customers or invoices in QB. Sure not in vba but in other >programming languages. >There are also some QDBC drivers which will allow write access to QB. > >Maybe it will help a little bit. > >Ulrich *--- Thank you! -paul
[toc] | [prev] | [standalone]
Back to top | Article view | comp.databases.ms-access
csiph-web