When you export a large volume of data to Excel 2007 workbooks, you can receive the following error:

NOTE: File "c:\sastest\testexport.xlsx" will be created if the export process succeeds.
ERROR: Execute: Unable to insert row 
WARNING: File deletion failed for _IMEX_.Data.DATA. 
ERROR: Export unsuccessful. See SAS Log for details. 

The error occurs when you run an EXPORT procedure similar to the following:

The problem occurs because the SAS System uses the Microsoft Access Connectivity Engine to create these files. When you use large files that exceed approximately 50,000,000 cells, the Access Connectivity Engine uses more memory than a single Windows process has available.

To circumvent the problem, you should divide the data across multiple sheets. SAS Note 16587, "Exporting SAS data sets of more than 65,536 rows to Microsoft Excel", contains a program that you can use to split the data. You can set the program as high as the number of rows the machine's memory allows.

Operating System and Release Information