You are migrating data from QuickBooks to Microsoft Office Accounting Professional, to Microsoft Office Accounting Express, or to Microsoft Office Small Business Accounting. After you select a QuickBooks company file, you may receive the following error message:
The selected file is not valid. You must select another file.
This problem occurs when one of the following conditions is true:
- You are migrating an unsupported version of QuickBooks.
- You are importing an unsupported file type.
- The .qbw file that you try to migrate contains damaged transactions or errors that conflict with the migration.
To resolve this problem, use the following three methods in the order in which they are presented.
Method 1: Verify that you have the most recent updates
- Verify that you are using a supported version of QuickBooks. To do this, visit the following Microsoft Web site:
- Download the following items:
- Install the latest service pack for Accounting Professional, for Accounting Express, or for Small Business Accounting 2006. To obtain the latest service pack, visit the following Microsoft Web site, and then click Get the latest Office Accounting 2007 service pack or Small Business Accounting 2006 service pack:
- Install the latest Transaction Migration update. To obtain the latest Transaction Migration update, visit the following Microsoft Web site:
Method 2: Verify that you are using the correct file name extension
Verify that the file name extension of the QuickBooks company file that you try to migrate is .qbw. If the file name extensions are not displayed when you view the QuickBooks company file, follow these steps:
- Right-click Start, and then click Explore.
- On the Tools menu, click Folder Options.
- In the Folder Options dialog box, click the View tab.
- In the Advanced Settings pane, click to clear the Hide extensions for known file types option.
- Click Apply.
Method 3: Rebuild the QuickBooks company file
If you have verified that you have all the most recent updates and that you are using a supported version and file type, the likely problem is that the QuickBooks company data is damaged. To correct this problem, you must run the Rebuild Data utility in QuickBooks. To do this, follow these steps:
- In QuickBooks, open the company that you want.
- On the Window menu, click Close All.
- On the File menu, point to Utilities, and then click Rebuild Data.
- Click OK when you are prompted to make a backup.
Note Rebuilding requires that you back up your company file.
- Click No if you are prompted with the question of whether you want to replace the backup file. To avoid overwriting your current file, type a new name in the Filename field.
Note Do not replace your current backup. Instead, use other media for this backup, or back up to the hard disk.
- In the Back up Company File window, click Back Up.
- The Rebuild Data utility will start as soon as the backup is completed. Click OK when you receive a message that states that the rebuild has been completed.
- Close your company data file, and then reopen it to update the lists in the file:
- On the File menu, click Close Company.
- On the File menu, click Open Company.
- Select the company that you want to open, and then click Open.
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.