473,569 Members | 2,691 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Quickbooks functions

ARC
Hello all,

Does anyone have any access functions for quickbooks integration, or have a
link with access examples for some basic importing / exporting?

Many Thanks,

Jun 27 '08 #1
10 2220
PW
On Thu, 15 May 2008 13:10:48 -0500, "ARC" <PC*****@PCESof t.invalid>
wrote:
>Hello all,

Does anyone have any access functions for quickbooks integration, or have a
link with access examples for some basic importing / exporting?

Many Thanks,
I've been wanting to know how to export from Access and import into
Quickbooks for years and the only "answer" that I got was to check out
the Quickbooks Software Developer's Kit which I've never been able to
locate or find out what it's all about (Intuit's website is terrible,
IMO), or what it costs. And what language it's written in.

I've even offered to pay anyone here to do it here but I don't think
anyone knows how. Search this newsgroup in Google Groupls for
"Quickbooks " and see if you can find any thing useful. I haven't.

Good luck!

-pw
Jun 27 '08 #2

"PW" <pa************ **********@remo vehotmail.comwr ote in message
news:g0******** *************** *********@4ax.c om...
On Thu, 15 May 2008 13:10:48 -0500, "ARC" <PC*****@PCESof t.invalid>
wrote:
>>Hello all,

Does anyone have any access functions for quickbooks integration, or have
a
link with access examples for some basic importing / exporting?

Many Thanks,

I've been wanting to know how to export from Access and import into
Quickbooks for years and the only "answer" that I got was to check out
the Quickbooks Software Developer's Kit which I've never been able to
locate or find out what it's all about (Intuit's website is terrible,
IMO), or what it costs. And what language it's written in.

I've even offered to pay anyone here to do it here but I don't think
anyone knows how. Search this newsgroup in Google Groupls for
"Quickbooks " and see if you can find any thing useful. I haven't.

Good luck!
For the SDK, see www.developer.intuit.com

To import data into QuickBooks, you need to create a text file in the IIF
format or QB's XML format. IIF is documented (somwhat in) QB Help and on
the QuickBooks website. XML is documented on the SDK website.
-pw

Jun 27 '08 #3
ARC
I had a look at the SDK a number of years ago and had no luck. For whatever
reason, I wasn't able to get a handle on their file formats (IIF format).
Wish there were some access examples out there, or even straight vb. I'll
search some more, because I really don't think I'll figure it out from the
SDK. Thanks for the response.
"Karl" <so*****@sbcglo bal.bizwrote in message
news:RC******** *********@flpi1 48.ffdc.sbc.com ...
>
"PW" <pa************ **********@remo vehotmail.comwr ote in message
news:g0******** *************** *********@4ax.c om...
>On Thu, 15 May 2008 13:10:48 -0500, "ARC" <PC*****@PCESof t.invalid>
wrote:
>>>Hello all,

Does anyone have any access functions for quickbooks integration, or have
a
link with access examples for some basic importing / exporting?

Many Thanks,

I've been wanting to know how to export from Access and import into
Quickbooks for years and the only "answer" that I got was to check out
the Quickbooks Software Developer's Kit which I've never been able to
locate or find out what it's all about (Intuit's website is terrible,
IMO), or what it costs. And what language it's written in.

I've even offered to pay anyone here to do it here but I don't think
anyone knows how. Search this newsgroup in Google Groupls for
"Quickbooks " and see if you can find any thing useful. I haven't.

Good luck!
For the SDK, see www.developer.intuit.com

To import data into QuickBooks, you need to create a text file in the IIF
format or QB's XML format. IIF is documented (somwhat in) QB Help and on
the QuickBooks website. XML is documented on the SDK website.
>-pw

Jun 27 '08 #4
PW
On Thu, 15 May 2008 17:16:18 -0500, "Karl" <so*****@sbcglo bal.biz>
wrote:
>
"PW" <pa************ **********@remo vehotmail.comwr ote in message
news:g0******* *************** **********@4ax. com...
>On Thu, 15 May 2008 13:10:48 -0500, "ARC" <PC*****@PCESof t.invalid>
wrote:
>>>Hello all,

Does anyone have any access functions for quickbooks integration, or have
a
link with access examples for some basic importing / exporting?

Many Thanks,

I've been wanting to know how to export from Access and import into
Quickbooks for years and the only "answer" that I got was to check out
the Quickbooks Software Developer's Kit which I've never been able to
locate or find out what it's all about (Intuit's website is terrible,
IMO), or what it costs. And what language it's written in.

I've even offered to pay anyone here to do it here but I don't think
anyone knows how. Search this newsgroup in Google Groupls for
"Quickbooks " and see if you can find any thing useful. I haven't.

Good luck!
For the SDK, see www.developer.intuit.com
And how much does it cost to become a member so I can use it? I seem
to remember it was extremely expensive. We have a work around (QB
class report where the user spends 5 minutes max to import the income
data from our app into their QB classes) - But yet, one of the first
questions we get is "Does your product have a QB interface"? With so
many versions of Quickbooks and their other product(s) I wish we could
get it to work but guess we will stick to our guns.
>
To import data into QuickBooks, you need to create a text file in the IIF
format or QB's XML format. IIF is documented (somwhat in) QB Help and on
the QuickBooks website. XML is documented on the SDK website.
>-pw
Jun 27 '08 #5
On May 16, 2:02*pm, PW <paulremove_wil liamson...@remo vehotmail.com>
wrote:
On Thu, 15 May 2008 17:16:18 -0500, "Karl" <some...@sbcglo bal.biz>
wrote:


"PW" <paulremove_wil liamson...@remo vehotmail.comwr ote in message
news:g0******** *************** *********@4ax.c om...
On Thu, 15 May 2008 13:10:48 -0500, "ARC" <PCES...@PCESof t.invalid>
wrote:
>>Hello all,
>>Does anyone have any access functions for quickbooks integration, or have
a
link with access examples for some basic importing / exporting?
>>Many Thanks,
I've been wanting to know how to export from Access and import into
Quickbooks for years and the only "answer" that I got was to check out
the Quickbooks Software Developer's Kit which I've never been able to
locate or find out what it's all about (Intuit's website is terrible,
IMO), or what it costs. *And what language it's written in.
I've even offered to pay anyone here to do it here but I don't think
anyone knows how. *Search this newsgroup in Google Groupls for
"Quickbooks " and see if you can find any thing useful. *I haven't.
Good luck!
For the SDK, seewww.develope r.intuit.com

And how much does it cost to become a member so I can use it? *I seem
to remember it was extremely expensive. *We have a work around (QB
class report where the user spends 5 minutes max to import the income
data from our app into their QB classes) - But yet, one of the first
questions we get is "Does your product have a QB interface"? *With so
many versions of Quickbooks and their other product(s) I wish we could
get it to work but guess we will stick to our guns.


To import data into QuickBooks, you need to create a text file in the IIF
format or QB's XML format. IIF is documented *(somwhat in) QB Help and on
the QuickBooks website. XML is documented on the SDK website.
-pw- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -
Have a look at QODBC - claims to provide ODBC for Quickbooks
Jun 27 '08 #6
QODBC is not a direct link to the QB file. It sits on top of the SDK.

"Steve" <st**********@g mail.comwrote in message
news:eb******** *************** ***********@l28 g2000prd.google groups.com...
On May 16, 2:02 pm, PW <paulremove_wil liamson...@remo vehotmail.com>
wrote:
On Thu, 15 May 2008 17:16:18 -0500, "Karl" <some...@sbcglo bal.biz>
wrote:


"PW" <paulremove_wil liamson...@remo vehotmail.comwr ote in message
news:g0******** *************** *********@4ax.c om...
On Thu, 15 May 2008 13:10:48 -0500, "ARC" <PCES...@PCESof t.invalid>
wrote:
>>Hello all,
>>Does anyone have any access functions for quickbooks integration, or
have
a
link with access examples for some basic importing / exporting?
>>Many Thanks,
I've been wanting to know how to export from Access and import into
Quickbooks for years and the only "answer" that I got was to check out
the Quickbooks Software Developer's Kit which I've never been able to
locate or find out what it's all about (Intuit's website is terrible,
IMO), or what it costs. And what language it's written in.
I've even offered to pay anyone here to do it here but I don't think
anyone knows how. Search this newsgroup in Google Groupls for
"Quickbooks " and see if you can find any thing useful. I haven't.
Good luck!
For the SDK, seewww.develope r.intuit.com

And how much does it cost to become a member so I can use it? I seem
to remember it was extremely expensive. We have a work around (QB
class report where the user spends 5 minutes max to import the income
data from our app into their QB classes) - But yet, one of the first
questions we get is "Does your product have a QB interface"? With so
many versions of Quickbooks and their other product(s) I wish we could
get it to work but guess we will stick to our guns.


To import data into QuickBooks, you need to create a text file in the IIF
format or QB's XML format. IIF is documented (somwhat in) QB Help and on
the QuickBooks website. XML is documented on the SDK website.
-pw- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -
Have a look at QODBC - claims to provide ODBC for Quickbooks
Jun 27 '08 #7
The SDK is FREE.

"PW" <pa************ **********@remo vehotmail.comwr ote in message
news:hl******** *************** *********@4ax.c om...
On Thu, 15 May 2008 17:16:18 -0500, "Karl" <so*****@sbcglo bal.biz>
wrote:
>>
"PW" <pa************ **********@remo vehotmail.comwr ote in message
news:g0****** *************** ***********@4ax .com...
>>On Thu, 15 May 2008 13:10:48 -0500, "ARC" <PC*****@PCESof t.invalid>
wrote:

Hello all,

Does anyone have any access functions for quickbooks integration, or
have
a
link with access examples for some basic importing / exporting?

Many Thanks,

I've been wanting to know how to export from Access and import into
Quickbooks for years and the only "answer" that I got was to check out
the Quickbooks Software Developer's Kit which I've never been able to
locate or find out what it's all about (Intuit's website is terrible,
IMO), or what it costs. And what language it's written in.

I've even offered to pay anyone here to do it here but I don't think
anyone knows how. Search this newsgroup in Google Groupls for
"Quickbooks " and see if you can find any thing useful. I haven't.

Good luck!
For the SDK, see www.developer.intuit.com

And how much does it cost to become a member so I can use it? I seem
to remember it was extremely expensive. We have a work around (QB
class report where the user spends 5 minutes max to import the income
data from our app into their QB classes) - But yet, one of the first
questions we get is "Does your product have a QB interface"? With so
many versions of Quickbooks and their other product(s) I wish we could
get it to work but guess we will stick to our guns.
>>
To import data into QuickBooks, you need to create a text file in the IIF
format or QB's XML format. IIF is documented (somwhat in) QB Help and on
the QuickBooks website. XML is documented on the SDK website.
>>-pw

Jun 27 '08 #8
On Fri, 16 May 2008 09:10:42 -0500, "Karl" <so*****@sbcglo bal.bizwrote:
>The SDK is FREE.
Not for me it wasn't.
Wayne Gillespie
Gosford NSW Australia
Jun 27 '08 #9
ARC
I get the same question very frequently from prospective customers. As for
me, I have a quoting/invoicing program mainly for computer resellers. When I
sold computers, I would always let my program track the detail, such as
serial numbers sold, warranty, invoice details, etc. Then I would simply
make daily summary entries into Quicken (not quickbooks) that would have a
split trans for the deposit, breaking it into parts for resale, tax
collected, etc.

I can never figure why customers need to have the detail in both programs.
To me, keep the detail in one, then do summary entries, checks written,
deposits in quick books.
"PW" <pa************ **********@remo vehotmail.comwr ote in message
news:hl******** *************** *********@4ax.c om...
On Thu, 15 May 2008 17:16:18 -0500, "Karl" <so*****@sbcglo bal.biz>
wrote:
>>
"PW" <pa************ **********@remo vehotmail.comwr ote in message
news:g0****** *************** ***********@4ax .com...
>>On Thu, 15 May 2008 13:10:48 -0500, "ARC" <PC*****@PCESof t.invalid>
wrote:

Hello all,

Does anyone have any access functions for quickbooks integration, or
have
a
link with access examples for some basic importing / exporting?

Many Thanks,

I've been wanting to know how to export from Access and import into
Quickbooks for years and the only "answer" that I got was to check out
the Quickbooks Software Developer's Kit which I've never been able to
locate or find out what it's all about (Intuit's website is terrible,
IMO), or what it costs. And what language it's written in.

I've even offered to pay anyone here to do it here but I don't think
anyone knows how. Search this newsgroup in Google Groupls for
"Quickbooks " and see if you can find any thing useful. I haven't.

Good luck!
For the SDK, see www.developer.intuit.com

And how much does it cost to become a member so I can use it? I seem
to remember it was extremely expensive. We have a work around (QB
class report where the user spends 5 minutes max to import the income
data from our app into their QB classes) - But yet, one of the first
questions we get is "Does your product have a QB interface"? With so
many versions of Quickbooks and their other product(s) I wish we could
get it to work but guess we will stick to our guns.
>>
To import data into QuickBooks, you need to create a text file in the IIF
format or QB's XML format. IIF is documented (somwhat in) QB Help and on
the QuickBooks website. XML is documented on the SDK website.
>>-pw
Jun 27 '08 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
10289
by: behindspace | last post by:
is this possible, or does my client need to enter information in the DB manually (which I will end up doing for them) any ideas or links would be great, thanks in advance!
2
2798
by: news | last post by:
We're being asked to get Quickbooks Enterprise edition for our business. We use a completely hand-made online store (PHP and mySQL) and used to simply create CSV sheets that were imported as invoices into regular Quickbooks. But I guess that's neither 100% accurate and may not even be doable in newer Quickbooks. We want to be able to...
2
1737
by: Benny | last post by:
Does anyone know if you have to have a specific version of QuickBooks and Peachtree to integrate a website's "shopping cart" feature? Some of my clients have QuickBooks and some use Peachtree, I am trying to integrate our Custom ASP shopping cart with them. Can some one help? Kind Regards Benny Macronimous.com
3
13549
by: cbielich | last post by:
Just as the subject states, if I were to write an Access Datase is it possible to intergrate it with quickbooks. For instance through ODBC or something of the sort. Im not sure how the backend of QuickBooks works as in does it use a database with tables or something of the sort. Just would like to intergrate a database and using it with...
3
6950
by: Aliza Klein | last post by:
I have a client who wants to export his Access purchase order data (from the system I am designing) directly into Quickbooks. I know I can create a CSV or similar that Quickbooks can then import - but does anyone know if Quickbooks can be referenced directly (like an instance of Excel etc.) and "talked" to? TIA Aliza --...
2
8297
by: Raghu Gupta | last post by:
Hi, Actually i am facing some problem using quickbooks and presently i am not so expert in using it. I am using c# code to retrive the data from quickbooks. it doesn't matter which language we are using. So i have .iif file of employee list,so through code i have to read .iif file and get the data out of it and store that data in database....
14
2560
by: Kevin G. Anderson | last post by:
What: CAUG Meeting - QuickBooks IIF Files; Total Access Analyzer; CAUG Social When: Thursday, May 25, 2006, 6PM Who: Chris Monaghan and Kevin Anderson Where: The Information Management Group 200 W. Monroe St. Suite 900 Chicago, IL 60606 (312) 222-9400 Location: www.imginc.com/IMG/About+IMG/chicago.htm
6
3555
by: Jimmy | last post by:
I am developing a project management database for my company and would like to somehow integrate or share data from my quickbooks file. I am currently using Access 2003 and Quickbooks 2003 Pro. In my access database I have a much more in depth customer database but would like to eliminate the need to enter new customers and addresses twice,...
1
1616
by: Student1000 | last post by:
Ok, i have an access database which is connected to quickbooks in order to make invoices. One of the variables sent to quickbooks is job number. Recently, we 've been having very long(more digits) job numbers that are too big for the textbox in quickbooks. When i click the 'sendtoquickbooks' button in access form, i get an error saying something...
0
7695
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7612
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7922
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7668
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
5218
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3653
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3637
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2111
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
936
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.