When exporting a report to Excel, the formatting of records are:
Wrapping to the next line.
Are mis-aligned.
Have extra blank rows.
Some of the older format (Classic) reports in Attaché do not export data neatly into individual rows when exported to Excel or Notepad. The suggested workarounds for improve the exporting to Excel are as follows.
Export the report to Notepad and then open it in Excel
Preview the required report to screen.
Select the Notepad (F6) option from the toolbar in the preview screen.
Save the Notepad format to a known location.
Right click on the saved Notepad file and choose Open With and select Microsoft Excel.
When asked for options choose Fixed Length (not Delimited).
Click Next, again Next and then Finish. This should format the data in a more readable and workable way.
Other workarounds to get the required data in a working format
If you can obtain the data you require from a similar new format (DEVX) Attaché report, then these Attaché reports export to Excel directly in a much better format.
You can use the List Wizard feature (for Masterfile data).
You can also obtain information directly from the Attaché database tables using Attaché ODBC.