|
|
 |
QTableGrabber
is an Excel Add-In that gives you access to QuickBooks data
tables with virtually no limitation on transaction accessibility other
than certain payroll information that Intuit does not make available
outside its QuickBooks product line.
You can import single or multiple data sets directly into an existing
spreadsheet with no programming knowledge; you can grab information into
an Excel spreadsheet to create an infinite number of immediate analysis
scenarios; or you can query data into a spreadsheet that you just want
to periodically refresh without cutting, pasting, or reformatting every
time.
Key Features:
 | Place QuickBooks data in any cell,
column, or sheet you want
Access to all transaction data except for certain Intuit protected
payroll information |
| No programming knowledge necessary
|
| Uses the only ODBC driver for
QuickBooks: QODBC by FLEXquarters |
| Available as a menu item in Excel
|
| Eliminate cutting and pasting every
time you want to update your spreadsheet |
| Create multiple data requests in the
same spreadsheet; i.e. January information on sheet 1, February
information on sheet 2, etc. |
| Delete or add queries without
affecting your existing spreadsheet structure. |
| Overcome the limits imposed by
Microsoft Query |
| You can filter and sort your
QuickBooks data query by any field |
| QuickBooks reports give you certain
filtering and sorting options; QTableGrabber gives you many options
not available in QuickBooks. |
Microsoft Excel running QTableGrabber
Quick and Easy Steps:
| Create a new spreadsheet (or use an
existing one) |
| Query the QuickBooks data you want
|
| Refresh data every time you open up
the spreadsheet |
| No more cutting and pasting
|
| No more re-formatting |
Why QTableGrabber
vs. Other Tools?
When Intuit opened up access to
QuickBooks by providing the QuickBooks qbXML SDK interface (which is
used by our tools), it sounded the death knell for the IIF format.
Intuit will no longer promote or support third party applications on the
Intuit Marketplace if they use the old IIF format. Intuit will
eventually discontinue the IIF interface because it has no built-in
security and could allow invalid data to be imported into QuickBooks.
This is how QTableGrabber works with Live Data Links!
QuickBooks already Exports Lists?
Exporting lists has been available in
QuickBooks for years, but in order to filter or update the data, you
must manipulate your spreadsheet with cutting, pasting, deleting,
sorting, etc. to get the desired results you want. So if you wanted to
get a subset of your list data, you could only do so AFTER you have
opened up your IIF file in Excel and exported it.
QuickBooks does not have the ability to export transaction data from
within QuickBooks. Knowledge of the qbXML SDK, or having your personal
programmer would be necessary to extract this data from QuickBooks. QTableGrabber
is the only tool available to extract both list and transaction data
from QuickBooks without requiring the end user to be a programmer.
Microsoft has a built in Query Tool?
Microsoft allows you to import data
directly into Excel, but there are limitations that QTableGrabber
overcomes.
QTableGrabber allows query fields to be placed in your choice of sheets,
columns, or cells; Microsoft Query only allows a starting cell, with no
other placement options. It extracts data in several easy steps, while requiring no
knowledge of SQL. Microsoft Query requires you to manually re-connect to
the QODBC data source for each new query, and requires some knowledge of
SQL statements when editing a query.
Evaluation Download
If you would like to evaluate
QTableGrabber for free before purchasing, simply download the
product below! No registration code is required during the first 30 days.
To start using QTableGrabber, you first need to run QuickBooks on your computer logged in as an
Administrator and open your company file, or one of the sample company
files that came with QuickBooks. This is for security reasons.
If you are unable to download our products over the
internet you can order a
QODBC Product Family CD-ROM
to be sent out to you by clicking
here.
QTableGrabber
supports Australian, New
Zealand and Singapore editions of QuickBooks
2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003 Pro, Premier, Accountant and
Enterprise. QTableGrabber doesn't work with QuickBooks EasyStart, Accounting
(formally known as Lite), Plus or Small Business Editions.
Announcement List
To be alerted to news about QTableGrabber, product releases, beta
test cycles, new features and promotions subscribe to QODBC News Asia
Pacific.
QTableGrabber Pricing :
|
Description |
SKU # |
Price |
|
QTableGrabber
for QuickBooks Pro, Premier, Accountant and Enterprise
2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003
Australian Edition |
QTOZ4 |
A$217.80 |
|
QTableGrabber
for QuickBooks Pro, Premier, Accountant and Enterprise
2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003
New Zealand,
Singapore or
SE Asia Edition |
QTAP4 |
A$198.00 |
Customer Helpdesk System
Implemented for Tech Support
With the increased amount of pre-sales
and technical questions, due to the popularity of our products, we had to
rethink our previous methods of handling these types of phone calls and
email. So to serve you in a more efficient manner, we have implemented
the centralised QODBC support system from USA which is a web based
ticket system that you as a customer can input into directly with a
much faster response time.
The Customer Helpdesk system has a FAQ
(Frequently Asked Questions) knowledge base section that can be accessed
using the "Search for Answers" keyword search function on our web
pages, often finding the answers immediately. The FAQ Knowledge Base is
growing on a daily basis, so if you can’t find what you’re looking for
within your "Search for Answers" keyword search, submit a Support
Ticket. Your question or
technical problem will receive a same day reply even if you are just
evaluating our products or a fully registered user. We have 6 technical
people monitoring this system in order to provide you with resource
direction or answers to your questions. Click
here to go to the
QODBC HelpDesk System
to submit a Support Ticket.
Telephone Support Pricing:
When you purchase a QODBC product you are
entitled to Free
Installation Support for the first 30 days from the date of purchase. Program
anomalies will be addressed at no charge and updaters posted on our web
site. Evaluation and other support issues will be
subject to a A$33.00 per incident fee. Make sure you have the Serial
Number of your purchased product and call
03 9761 3644 or
+61 3 9761 3644
during our normal office business hours between 9am to 5pm
week days
Australian EST (with the
exception of Public Holidays).
Telephone Support Incidents
Evaluation and non-installation support issues are subject to a A$33.00 per incident
fee. Program anomalies will be addressed at no charge and updaters
posted on our web site. Please make sure you have the Serial Number of your purchased
product and call
03 9761 3644 or
+61 3 9761 3644 during our normal
office business hours between 9am to 5pm week days Australian EST (with
the exception of Public Holidays) or send your support emails to
support@DataAccess.com.au along with your payment
receipt.
Payments for Support Incidents may be made by clicking
here or by using the
following link:
http://www.dataaccess.com.au/en-gb/dept_113.html
 |
|
Q:
What is ODBC?
A: ODBC (Open DataBase Connectivity)
is a specification designed by Microsoft to allow Windows applications
to access multiple database systems through a single method with no
regard for various file formats. SQL (Structured Query Language) is used
as the method for accessing data through ODBC. Vendors of ODBC drivers
(like this one) follow the specifications for ODBC so that any ODBC
compliant application can access the data available through the driver.
Q: What is QODBC?
A: QODBC is an ODBC driver (DLL) for
QuickBooks Accounting format files. QuickBooks Accounting stores it's
data in it's own proprietary DBMS file format. This driver allows users
of any ODBC compliant front-end application to read and write data
contained in QuickBooks Accounting format files similarly to any other
ODBC enabled database.
Q: What can I do with QODBC?
A: QODBC opens up the QuickBooks
Accounting files created by thousands of custom programs to the new
world of database connectivity. Microsoft Access or Visual Basic can be
used to merge QuickBooks Accounting data with other data sources to
produce complex reports, or to run mass file updates based on multiple
criteria.
Q: What kind of learning curve is there for
QODBC?
A: After quick installation of the
driver, no training is required! This driver is transparent, requires no
learning curve and works in exactly the same fashion of other ODBC
drivers. Users of ODBC compliant front-end applications do not
necessarily need to learn SQL language to access the QuickBooks database
files. Many of these ODBC compliant applications simply present wizards
enabling the user to create queries against the database.
|
|
|
