QuickBooks Desktop 2017 Data Extraction: Exports and ODBC Guide

Learn how to keep QuickBooks Desktop 2017 data readable long-term using PDF and CSV report exports, IIF exports, and ODBC database access without Intuit su

If you are running QuickBooks Desktop 2017, you are already operating past its May 31, 2020 sunset date. One of the most critical aspects of maintaining a discontinued version is ensuring your financial data remains accessible and readable for the long term. Whether you need to share data with an accountant, migrate records to a specialized system, or simply create a permanent offline archive, getting your data out safely is entirely possible without Intuit support or forced upgrades.

Exporting Reports to PDF and CSV

QuickBooks Desktop 2017 retains all its built-in reporting and export functionalities. Because the reporting engine operates locally, the loss of Intuit's online services has zero impact on your ability to generate and save reports.

The process for exporting reports is identical across QuickBooks Desktop versions:

1. Open the report you need (e.g., Profit and Loss, Balance Sheet, General Ledger).
2. Click the Export icon at the top of the report window (usually represented by a downward-pointing arrow or an "Export" button).
3. Choose Export to Excel Worksheet, Export to CSV, or Export to PDF.

For long-term digital archiving, PDF is generally the safest choice because it preserves the visual layout and is universally readable. CSV (Comma-Separated Values) is highly recommended for raw data preservation. Saving your core financial statements as CSV ensures the raw numbers can be imported into future spreadsheet software or analyzed externally, even if proprietary reporting formats change decades down the line.

IIF Exports for Raw Data

Intuit Interchange Format (IIF) is a legacy, tab-delimited text format used to move transactional data in and out of QuickBooks. While Intuit has shifted focus toward newer web connectors in subsequent years, QuickBooks Desktop 2017 fully supports IIF, making it an excellent tool for extracting bulk lists and historical transactions.

To export data via IIF:

1. Go to File > Utilities > Export > Export IIF Files.
2. Choose the specific lists (such as the Chart of Accounts, Customer List, or Vendor List) or transactions you want to extract.
3. Save the resulting .iif file to your local drive or an external backup drive.

Because IIF files are essentially plain text, they are highly durable. You can open them in any basic text editor or spreadsheet program to audit the raw data, ensuring your historical records remain readable long after the QuickBooks 2017 application itself is retired.

Accessing Data via ODBC

For advanced users who need to query their company file using database tools (like Microsoft Access, Excel Power Query, or SQL Server), QuickBooks data can be accessed via ODBC (Open Database Connectivity).

QuickBooks Desktop uses the QODBC driver to translate standard SQL queries into QuickBooks SDK calls. To use ODBC with QuickBooks 2017, you must have the QuickBooks application running in the background with your company file open in Single-User Mode. The ODBC connection reads the live .qbw file through the SDK, meaning you cannot query a company file directly without the QuickBooks software running.

If you are relying on ODBC for long-term data extraction, keep these points in mind:

• Driver Availability: QuickBooks Desktop 2017 shipped with an integrated QODBC driver. Ensure your installation is intact, as downloading legacy drivers directly from Intuit may no longer be possible.
• Read-Only Queries: For safe data extraction, set your ODBC connection to read-only. This prevents accidental data modification through external SQL commands.
• Static Extraction: Because ODBC requires the live QuickBooks application to function, it is not a permanent, standalone database solution. Use it to run queries and export the results to standard formats (like CSV or SQL databases) for permanent safekeeping.

Creating a Decades-Long Data Archive

To ensure your 2017 data survives hardware and software changes, combine these export methods into a comprehensive archive strategy. Generate a complete set of financial statements as PDFs for human readability, export your core lists and historical transactions as IIF and CSV files for software portability, and use ODBC to pull any highly specific transaction queries into an external database.

Once you have exported these files, move them off your primary business machine. Store them on multiple offline mediums—such as an external hard drive and a secure local network storage device. By creating these universal file formats now, you guarantee that your financial history remains accessible entirely on your own terms.