Gary: I just now spent some time playing around with this, and you're
right. The Data Interchange Format did a nearly perfect job of printing
multi-column reports to a ".dif" file. I had never heard of that extension
before,
but the "open after printing" brings it up in Excel. The only problem I
had was a report that had a wrapping DBMemo control in each row at the far
right; lines after the first one were showing up in the previous column. But
other then that, every report I tried exported very nicely!
Karen
> Just ran across something new in V9.1 on printing a report and getting
> into an XLS spreadsheet format. One of the options that exist on the Print
> to File is the Data Exchange Format. This seems to be a new feature with
> V9.1 I have found it translate the data with fewer changes than with
> printing to an EXCEL spreadsheet. The header information is a little funky,
> however the data seems to be translated better to the correct columns. I can
> live with that.
>
> I am not saying this is perfect, however, it seems to work better in the
> data translation than anything I have yet to try.
>
> Has anyone else tried this approach???
>
> Gary
>
>
>
>
>