Troubleshoot exporting in Access

This could be because the path to the required driver in the registry is invalid. For more information about how to correct this problem, see "Could not find installable ISAM" error message.

The green triangles are error indicators. The strings that begin with "#" are error values. Error indicators and error values indicate that the data didn't get exported properly. Search Excel Help for more information about troubleshooting error indicators and error values.

Access does not export Microsoft Graph objects to Excel during an export operation. To troubleshoot this limitation, see How to export a graph from Access to Excel.

Null values sometimes get replaced with the data that should be in the next column in the resulting worksheet. For more information about when and why this problem occurs, and how to resolve it, see Nulls replaced with next field's data when you export to Excel.

Date values earlier than Jan 1, 1900 do not get exported. The worksheet will contain null values, instead. For more information about how to resolve this, see Exporting dates may result in nulls or cause "Numeric Field Overflow" error.

If you start the export operation from the Database window or in Form view, check boxes on forms will not get exported. The corresponding column in the worksheet will display "#". To solve this situation, open the form in Datasheet view before exporting it. The corresponding column in the worksheet will contain TRUE or FALSE, depending on the selected status of the check box in the form.

Subforms are ignored during the export operation. Export the subform separately.

All graphical elements, such as a logo, background picture, and contents of OLE object fields that are part of the exported data, will not get exported.

When you output a report to Excel, memo fields are truncated to 255 characters. You may also see this behavior when you click the Analyze It with Microsoft Excel command while you are previewing a report. For information about how to resolve this issue, see Troubleshooting truncated memo fields in reports.

After you output a report to Excel, if you notice that the totals are missing, see Troubleshooting missing report totals for information about how to resolve this issue.

When you open a workbook in Excel, and the workbook contains links to other Excel workbooks that are generated when a report in Access is exported to Excel, you might receive the "Unable to read file" message when you update the links in the workbook. To resolve this issue, see Troubleshooting "Unable to read file" error message.

If a table has more than 16,384 rows, and you use the Analyze It with Microsoft Excel command to copy data into Excel, you might get the "Too many rows" message. To resolve this issue, see Troubleshooting "Too many rows" error message.

You have not selected the Show hidden files and folders option in Microsoft Windows Explorer. See Windows Help for information about selecting this option.

Although you cannot link a database object to either Microsoft Internet Information Services (.htx, .idc) or Microsoft Active Server Pages (.asp) output formats, you can export (export: To copy data and database objects to another database, spreadsheet file, or file format so that another database or program can use the data or database objects. You can export data to a variety of supported databases, programs, and file formats.) the object to the desired output format and then attach the file in a mail program, such as Microsoft Office Outlook 2003.