Yes, this happens for me as well. Ran the upgrade to 6.22 and dictionary 23.

Taxon Occurrence Comment and Sample Location Description fields now export to Excel as (MEMO) if there is anything in the field and (Memo) if it is blank.

Should have mentioned that this happened running a saved report from right click on a location. Results appear normal in the Filter Result screen, but contain (MEMO) on opening the .xlsx file. Copy all and paste directly into XL doesn't do this.

Yes it does and it applies to any field which is of Text data type, so pretty much all Comment & Description fields anywhere in the database.

This needs an urgent fix. I really don't want to have to rollback the upgrade.

This sounds like a show stopper for us upgrading too.

This isn't an area where any changes were made. Will need to refer back to John to see what has happened here.

Could it be something caused by the NBN export addin? I seem to remember hearing about problems with comment field truncation there.

Sorry Mike, that made it worse.

I replaced the three files you supplied, then re-edited one of the items I had already changed as a short term fix (this being the Obs Comment output from the report wizard, to which I had added CONVERT(VARCHAR(254),...))

Now the report wizard crashes with a message that "String or binary data would be truncated".

date/time         : 2014-03-24, 12:33:24, 957ms
computer name     : WWT-0127
user name         : robl <admin>
registered owner  : User
operating system  : Windows 7 x64 Service Pack 1 build 7601
system language   : English
system up time    : 3 hours 25 minutes
program up time   : 4 minutes 18 seconds
processors        : 2x AMD Athlon(tm) II X2 215 Processor
physical memory   : 734/1791 MB (free/total)
free disk space   : (C:) 177.70 GB (Z:) 27.89 GB
display mode      : 1280x1024, 32 bit
process id        : $cc8
allocated memory  : 52.10 MB
command line      : RecorderApp.exe /394434
executable        : RecorderApp.exe
exec. date/time   : 2014-03-24 11:48
version           : 6.22.2.274
compiled with     : Delphi 7
madExcept version : 3.0n
callstack crc     : $5b5c45c7, $7e34b9e8, $7e34b9e8
exception number  : 1
exception class   : EOleException
exception message : String or binary data would be truncated.

main thread ($d8c):
0059bba6 RecorderApp.exe ADODB                    TADOCommand.Execute
0059bb00 RecorderApp.exe ADODB                    TADOCommand.Execute
0059bae0 RecorderApp.exe ADODB                    TADOCommand.Execute
00911fed RecorderApp.exe ReportGenerator 1107 +16 TReportGenerator.ExecuteSQL
00911de3 RecorderApp.exe ReportGenerator 1064 +31 TReportGenerator.PopulateAttributes
0090daaa RecorderApp.exe ReportGenerator  357  +7 TReportGenerator.PrepareData
009135f8 RecorderApp.exe WizardData       422  +3 TdmWizard.PrepareOutput
0092a3d2 RecorderApp.exe FilterResult     662 +19 TfrmFilterResult.UpdateResults
00929fae RecorderApp.exe FilterResult     572 +16 TfrmFilterResult.RunWizard
00929efb RecorderApp.exe FilterResult     550  +1 TfrmFilterResult.WMRunWizard
004dd130 RecorderApp.exe Controls                 TControl.WndProc
004e018f RecorderApp.exe Controls                 TWinControl.WndProc
004f7c5d RecorderApp.exe Forms                    TCustomForm.WndProc
004dfe0c RecorderApp.exe Controls                 TWinControl.MainWndProc
00430c3c RecorderApp.exe Classes                  StdWndProc
769e7bc5 user32.dll                               DispatchMessageA
004fe2fb RecorderApp.exe Forms                    TApplication.ProcessMessage
004fe332 RecorderApp.exe Forms                    TApplication.HandleMessage
004fe562 RecorderApp.exe Forms                    TApplication.Run
00a95918 RecorderApp.exe RecorderApp      414 +79 initialization
75b03368 kernel32.dll                             BaseThreadInitThunk

thread $b30:
77e50156 ntdll.dll                 NtWaitForMultipleObjects
760d15e3 KERNELBASE.dll            WaitForMultipleObjectsEx
75b019f7 kernel32.dll              WaitForMultipleObjectsEx
769f0864 user32.dll                MsgWaitForMultipleObjectsEx
769f0b64 user32.dll                MsgWaitForMultipleObjects
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
75b03368 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($d8c) at:
75b03490 kernel32.dll              CreateThread

thread $6f0:
77e51f3f ntdll.dll     NtWaitForWorkViaWorkerFactory
75b03368 kernel32.dll  BaseThreadInitThunk

thread $11c8:
77e50156 ntdll.dll     NtWaitForMultipleObjects
75b03368 kernel32.dll  BaseThreadInitThunk

thread $1348:
77e50156 ntdll.dll                 NtWaitForMultipleObjects
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
75b03368 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($d8c) at:
75b03490 kernel32.dll              CreateThread

thread $1038:
77e4f8ca ntdll.dll                 NtWaitForSingleObject
760d1497 KERNELBASE.dll            WaitForSingleObjectEx
75b0118f kernel32.dll              WaitForSingleObjectEx
75b01143 kernel32.dll              WaitForSingleObject
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
75b03368 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($d8c) at:
75b03490 kernel32.dll              CreateThread

thread $1170:
77e51f3f ntdll.dll     NtWaitForWorkViaWorkerFactory
75b03368 kernel32.dll  BaseThreadInitThunk

thread $2bc:
77e51f3f ntdll.dll     NtWaitForWorkViaWorkerFactory
75b03368 kernel32.dll  BaseThreadInitThunk

modules:
003d0000 MS5User.Dll               5.0.0.4            Z:
00400000 RecorderApp.exe           6.22.2.274         Z:
00d80000 C4DLL.DLL                 1.0.0.1            Z:
00e70000 ms5cnv.dll                5.0.0.10           Z:
06480000 GoToGridControl.ocx       2.0.0.16           Z:\Addins
06d70000 GoToKey.ocx               6.0.1.10           Z:\Addins
06e50000 GotoKey2.dll                                 Z:\Addins
08010000 LastKeyUpdate.ocx         6.0.0.6            Z:\Addins
08210000 NBNExchangeAddinNu.dll                       Z:\Addins
083f0000 ObsAdditionalInfo.ocx                        Z:\Addins
085b0000 ProjectManageUserTaxa.ocx                    Z:\Addins
08780000 ShowUnchecked.ocx         6.0.0.13           Z:\Addins
08990000 StdValLib.dll             6.15.1.230         Z:\Addins
10000000 MS5.Dll                   5.0.0.12           Z:
5dc20000 sqloledb.dll              6.1.7601.17514     C:\Program Files (x86)\Common Files\System\Ole DB
5dd10000 comsvcs.dll               2001.12.8530.16385 C:\Windows\system32
5de50000 msado15.dll               6.1.7601.17857     C:\Program Files (x86)\Common Files\System\ado
5e1d0000 msadce.dll                6.1.7601.17514     C:\Program Files (x86)\Common Files\System\msadc
5e260000 oledb32.dll               6.1.7601.17514     C:\Program Files (x86)\Common Files\System\Ole DB
5f730000 HHCtrl.ocx                6.1.7600.16385     C:\Windows\system32
5fbe0000 DBNETLIB.DLL              6.1.7600.16385     C:\Windows\system32
5fc10000 MSDATL3.dll               6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
5fc40000 SQLOLEDB.RLL              6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
5fc50000 odbc32.dll                6.1.7601.17514     C:\Windows\system32
5fe60000 odbcint.dll               6.1.7600.16385     C:\Windows\system32
5ff30000 OLEDB32R.DLL              6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
609b0000 cscapi.dll                6.1.7601.17514     C:\Windows\system32
60e70000 ntlanman.dll              6.1.7601.17514     C:\Windows\System32
60e90000 drprov.dll                6.1.7600.16385     C:\Windows\System32
61620000 msadcer.dll               6.1.7600.16385     C:\Program Files (x86)\Common Files\System\msadc
616b0000 netbios.dll               6.1.7600.16385     C:\Windows\system32
62350000 gdiplus.dll               6.1.7601.18120     C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7601.18120_none_72d2e82386681b36
69b10000 msxml4.dll                4.20.9876.0        c:\Windows\SysWOW64
6be40000 dwmapi.dll                6.1.7600.16385     C:\Windows\system32
6c010000 uxtheme.dll               6.1.7600.16385     C:\Windows\system32
6c580000 SHFolder.dll              6.1.7600.16385     C:\Windows\system32
6d610000 comctl32.dll              5.82.7601.18201    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.18201_none_ec80f00e8593ece5
6d760000 SXS.DLL                   6.1.7601.17514     C:\Windows\system32
6ec50000 winmm.dll                 6.1.7601.17514     C:\Windows\system32
6f600000 MSDART.DLL                6.1.7600.16385     C:\Windows\system32
6f620000 olepro32.dll              6.1.7601.17514     C:\Windows\system32
6f650000 security.dll              6.1.7600.16385     C:\Windows\system32
70360000 Comctl32.dll              6.10.7601.17514    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7601.17514_none_41e6975e2bd6f2b2
71d90000 wship6.dll                6.1.7600.16385     C:\Windows\System32
71da0000 ntdsapi.dll               6.1.7600.16385     C:\Windows\system32
72000000 rasadhlp.dll              6.1.7600.16385     C:\Windows\system32
72010000 fwpuclnt.dll              6.1.7601.18283     C:\Windows\System32
720a0000 wshtcpip.dll              6.1.7600.16385     C:\Windows\System32
720b0000 mswsock.dll               6.1.7601.18254     C:\Windows\system32
72120000 ATL.DLL                   3.5.2284.0         C:\Windows\system32
72260000 DNSAPI.dll                6.1.7601.17570     C:\Windows\system32
723a0000 wkscli.dll                6.1.7601.17514     C:\Windows\system32
723b0000 srvcli.dll                6.1.7601.17514     C:\Windows\system32
723d0000 netutils.dll              6.1.7601.17514     C:\Windows\system32
723e0000 NETAPI32.dll              6.1.7601.17887     C:\Windows\system32
730e0000 mpr.dll                   6.1.7600.16385     C:\Windows\system32
73300000 bcryptprimitives.dll      6.1.7600.16385     C:\Windows\SysWOW64
73340000 bcrypt.dll                6.1.7600.16385     C:\Windows\system32
73360000 cryptdll.dll              6.1.7600.16385     C:\Windows\system32
73380000 msv1_0.DLL                6.1.7601.17514     C:\Windows\SysWOW64
733d0000 credssp.dll               6.1.7601.17514     C:\Windows\system32
73430000 RpcRtRemote.dll           6.1.7601.17514     C:\Windows\system32
736a0000 wsock32.dll               6.1.7600.16385     C:\Windows\system32
737d0000 SECUR32.DLL               6.1.7601.18270     C:\Windows\system32
740c0000 rsaenh.dll                6.1.7600.16385     C:\Windows\system32
74100000 WINNSI.DLL                6.1.7600.16385     C:\Windows\system32
74110000 IPHLPAPI.DLL              6.1.7601.17514     C:\Windows\system32
74130000 CRYPTSP.dll               6.1.7600.16385     C:\Windows\system32
74150000 WINSTA.dll                6.1.7601.17514     C:\Windows\System32
74990000 DAVHLPR.dll               6.1.7600.16385     C:\Windows\System32
749b0000 davclnt.dll               6.1.7601.18201     C:\Windows\System32
75740000 winspool.drv              6.1.7601.17514     C:\Windows\system32
757a0000 version.dll               6.1.7600.16385     C:\Windows\system32
75870000 CRYPTBASE.dll             6.1.7600.16385     C:\Windows\syswow64
75880000 SspiCli.dll               6.1.7601.18270     C:\Windows\syswow64
758e0000 ADVAPI32.dll              6.1.7601.18247     C:\Windows\syswow64
759e0000 comdlg32.dll              6.1.7601.17514     C:\Windows\syswow64
75a60000 GDI32.dll                 6.1.7601.18275     C:\Windows\syswow64
75af0000 kernel32.dll              6.1.7601.18229     C:\Windows\syswow64
75d30000 RPCRT4.dll                6.1.7601.18205     C:\Windows\syswow64
75e20000 msvcrt.dll                7.0.7601.17744     C:\Windows\syswow64
75ed0000 CRYPT32.dll               6.1.7601.18277     C:\Windows\syswow64
75ff0000 SHLWAPI.dll               6.1.7601.17514     C:\Windows\syswow64
76050000 WS2_32.dll                6.1.7601.17514     C:\Windows\syswow64
760c0000 KERNELBASE.dll            6.1.7601.18229     C:\Windows\syswow64
76120000 MSCTF.dll                 6.1.7600.16385     C:\Windows\syswow64
761f0000 sechost.dll               6.1.7600.16385     C:\Windows\SysWOW64
76210000 NSI.dll                   6.1.7600.16385     C:\Windows\syswow64
76490000 ole32.dll                 6.1.7601.17514     C:\Windows\syswow64
76820000 CLBCatQ.DLL               2001.12.8530.16385 C:\Windows\syswow64
768b0000 LPK.dll                   6.1.7601.18177     C:\Windows\syswow64
768c0000 oleaut32.dll              6.1.7601.17676     C:\Windows\syswow64
769d0000 user32.dll                6.1.7601.17514     C:\Windows\syswow64
76ad0000 shell32.dll               6.1.7601.18222     C:\Windows\syswow64
778f0000 USP10.dll                 1.626.7601.18009   C:\Windows\syswow64
77990000 MSASN1.dll                6.1.7601.17514     C:\Windows\syswow64
779b0000 IMM32.DLL                 6.1.7601.17514     C:\Windows\system32
77e30000 ntdll.dll                 6.1.7601.18247     C:\Windows\SysWOW64

processes:
0000 Idle                0 0   0
0004 System              0 0   0
0164 smss.exe            0 0   0
01b8 csrss.exe           0 0   0
01ec wininit.exe         0 0   0
0208 csrss.exe           1 0   0
0230 services.exe        0 0   0
0250 winlogon.exe        1 0   0
026c lsass.exe           0 0   0
0278 lsm.exe             0 0   0
02d4 svchost.exe         0 0   0
0314 nvvsvc.exe          0 0   0
032c nvSCPAPISvr.exe     0 0   0
035c svchost.exe         0 0   0
03ac svchost.exe         0 0   0
03dc svchost.exe         0 0   0
03f8 svchost.exe         0 0   0
0174 svchost.exe         0 0   0
0490 svchost.exe         0 0   0
050c nvxdsync.exe        1 0   0
0520 nvvsvc.exe          1 0   0
0548 spoolsv.exe         0 0   0
0564 svchost.exe         0 0   0
05ac armsvc.exe          0 0   0
0628 svchost.exe         0 0   0
064c HSMServiceEntry.exe 0 0   0
067c klnagent.exe        0 0   0
0708 PassThruSvr.exe     0 0   0
0778 avp.exe             0 0   0
07e4 svchost.exe         0 0   0
0894 WUDFHost.exe        0 0   0
097c WUDFHost.exe        0 0   0
09a4 WUDFHost.exe        0 0   0
09d4 WUDFHost.exe        0 0   0
0a08 WUDFHost.exe        0 0   0
045c WUDFHost.exe        0 0   0
029c taskhost.exe        1 26  22  normal
0b64 dwm.exe             1 21  3   high
0bb4 explorer.exe        1 465 331 normal
0c94 adb.exe             1 4   2   normal C:\Program Files (x86)\HTC\HTC Sync Manager\HTC Sync
0dc0 daemonu.exe         0 0   0   normal
0e00 wuauclt.exe         1 12  6   normal
0eb4 avp.exe             1 83  20  normal C:\Program Files (x86)\Kaspersky Lab\Kaspersky Endpoint Security 10 for Windows
0fac nvtray.exe          1 81  4   normal
0ff0 SearchIndexer.exe   0 0   0
0414 OUTLOOK.EXE         1 625 274 normal C:\Program Files (x86)\Microsoft Office\Office14
0d58 OSPPSVC.EXE         0 0   0
1174 firefox.exe         1 93  48  normal C:\Program Files (x86)\Mozilla Firefox
0cc8 RecorderApp.exe     1 314 235 normal Z:
132c Ssms.exe            1 283 104 normal C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio
1104 unsecapp.exe        1 9   3   normal
0550 audiodg.exe         0 0   0

hardware:
+ Android USB Devices
  - My HTC (driver 2.0.7.13)
+ Computer
  - ACPI x64-based PC
+ Disk drives
  - Generic- Compact Flash USB Device
  - Generic- MS/MS-Pro/HG USB Device
  - Generic- SD/MMC USB Device
  - Generic- SD/MMC/MS/MSPRO USB Device
  - Generic- SM/xD-Picture USB Device
  - WDC WD2500AAKX-00U6AA0 ATA Device
+ Display adapters
  - NVIDIA GeForce 9100 (driver 9.18.13.1106)
+ DVD/CD-ROM drives
  - hp DVD-RAM GH40L ATA Device
  - HTC Android Phone USB Device
+ Human Interface Devices
  - USB Input Device
  - USB Input Device
+ IDE ATA/ATAPI controllers
  - ATA Channel 0
  - ATA Channel 1
  - ATA Channel 2
  - ATA Channel 3
  - Standard AHCI 1.0 Serial ATA Controller
+ IEEE 1394 Bus host controllers
  - LSI 1394 OHCI Compliant Host Controller
+ Keyboards
  - HID Keyboard Device
+ Mice and other pointing devices
  - HID-compliant mouse
+ Monitors
  - Generic PnP Monitor
+ Network adapters
  - NVIDIA nForce Networking Controller
+ Portable Devices
  - F:\
  - G:\
  - H:\
  - HTC MTP Device (driver 1.0.0.4)
  - I:\
  - J:\
+ Processors
  - AMD Athlon(tm) II X2 215 Processor
  - AMD Athlon(tm) II X2 215 Processor
+ Sound, video and game controllers
  - High Definition Audio Device
+ Storage volume shadow copies
  - Generic volume shadow copy
  - Generic volume shadow copy
  - Generic volume shadow copy
  - Generic volume shadow copy
+ System devices
  - ACPI Fixed Feature Button
  - ACPI Power Button
  - Composite Bus Enumerator
  - Direct memory access controller
  - File as Volume Driver
  - High Definition Audio Controller
  - High precision event timer
  - Microsoft ACPI-Compliant System
  - Microsoft System Management BIOS Driver
  - Microsoft Virtual Drive Enumerator Driver
  - Microsoft Windows Management Interface for ACPI
  - Microsoft Windows Management Interface for ACPI
  - Motherboard resources
  - Motherboard resources
  - Motherboard resources
  - Motherboard resources
  - Numeric data processor
  - NVIDIA nForce PCI System Management
  - NVIDIA nForce System Management Controller (driver 5.1.2600.171)
  - PCI bus
  - PCI standard host CPU bridge
  - PCI standard host CPU bridge
  - PCI standard host CPU bridge
  - PCI standard host CPU bridge
  - PCI standard host CPU bridge
  - PCI standard ISA bridge
  - PCI standard PCI-to-PCI bridge
  - PCI standard PCI-to-PCI bridge
  - PCI standard PCI-to-PCI bridge
  - PCI standard PCI-to-PCI bridge
  - PCI standard PCI-to-PCI bridge
  - PCI standard PCI-to-PCI bridge
  - PCI standard RAM Controller
  - PCI standard RAM Controller
  - PCI standard RAM Controller
  - Plug and Play Software Device Enumerator
  - Programmable interrupt controller
  - Remote Desktop Device Redirector Bus
  - System board
  - System CMOS/real time clock
  - System speaker
  - System timer
  - Terminal Server Keyboard Driver
  - Terminal Server Mouse Driver
  - UMBus Enumerator
  - UMBus Enumerator
  - UMBus Root Bus Enumerator
  - Volume Manager
+ Universal Serial Bus controllers
  - Standard Enhanced PCI to USB Host Controller
  - Standard Enhanced PCI to USB Host Controller
  - Standard OpenHCD USB Host Controller
  - Standard OpenHCD USB Host Controller
  - USB Composite Device
  - USB Mass Storage Device
  - USB Mass Storage Device
  - USB Root Hub
  - USB Root Hub
  - USB Root Hub
  - USB Root Hub

It was the report wizard and it crashed while producing the report, not while exporting.

I have just got back from lunch and from memory I think I tested the exact same report wizard settings after I had undone the latest change to make sure it didn't crash anyway. I will do a bit more testing just to make sure.

I did notice another thing, during the testing however. When exporting to excel, the file created overwrites an existing file of the same name without question. Is that normal?

Fair enough. That would bug the hell out of me if it was something I ever had to deal with on a regular basis. Fortunately I rarely export anything to excel myself.