to remedy the 256 byte truncation when exporting into excel
If you use the menu File, Export, you should be able to
select Excel 97-2000 as the file format. I would make
sure you have a complete install of MS Office.
If you are using VBA and the TransferSpreadsheet Method,
The spreadsheettypes is 8.