Intuit Quickbooks data can be accessed fast through this software tool.

AccessBooks Real Time lets you build solutions that can support several hundred concurrent users with a standard ODBC interface. ODBC connections to the Quickbooks often are slow and can cause aggravation. All data made available by Intuit through the QuickBooks API can be quickly and easily exported to a database. Using database replication AccessBooks RealTime natively synchronizes QuickBooks company file to an external Microsoft Accesss or to a Microsoft SQL Server, MySQL or Oracle database. This includes support for US, UK and Canadian versions. As typically the Quickbooks is the tool your accountants often use, you need to keep the database in the back end the Access or the SQL Server or whatever synchronized. You could set the sync frequency through a scheduler that is available with this application.

Reports generated in the Quickbooks, the accounting package, can be transferred into the database tables. AccessBooks RT also supports the extraction of custom fields, command line support and the ability to filter the exported QuickBooks data. Supported databases include Access, MS SQL, MySQL, and Oracle servers. You will be able to use the Crystal Reports suite of products with this tool to generate reports the way you want! The tool is able to extract data even from custom fields. The utility also provides a command line support. The intuitive interface makes it quite easy to keep data in the accounting package and databases synchronized. If you have to do this often in your typical workday, this can be a handy tool.