Open Database Connectivity (ODBC) is a standard application that allows different programs to communicate and exchange data with each other. Through ODBC, you can create spreadsheets in Excel, tables in Access, and create reports in Crystal Reports that reflect your real-time QuickBooks data.
You can also use this feature to design your own reports (even combining data from multiple company files), personalize invoices, create mail merges, etc. In addition, you can write your own queries using Structured Query Language (SQL).
The QODBC driver allows administrator access to your QuickBooks data using third-party applications such as Microsoft Excel, Access, or Crystal Reports.