I am trying to use the print command to create an XLS file with customer names. As the file is being created, I get an error as follows:
File Error: Data may have been lost. When I inspect the XLS file some of the data is misaligned (1st name does not match the last name). And some of the data is missing. In my test table there are 250 rows and the XLS file only contains 245 rows. I even stripped the table down to one column (FirstName) and I still get the error and the corrupted data. Here is the last print command that I tried. I experimented with dozens of other print options and they all produce the error. I suspect the resolution may be in the option settings. PRINT xls_out + OPTION XLS + |FILENAME MAILER.XLS + |SHOW_CANCEL_DIALOG Off + |CELL_ATTR ON + |LINE_SPACE actual + |OPEN ON return Does anyone have a suggestion. John Engwer Engwer & Associates 2449 Scenic Ridge Drive North Huntingdon, PA 15642-2120 Phone: 412 751-2433 Email: <mailto:[email protected]> [email protected] <http://www.ENGWER.US> WWW.ENGWER.US
