1 Reply by Lizzy Peat

  • Lizzy Peat
  • Lizzy Peat
  • Member
  • Offline
  • From: Hampshire (HBIC)
  • Registered: 17-05-2006
  • Posts: 38

Re: String or binary data would be truncated. .

Hello,

I am trying to import an Excel spreadsheet using the import wizard in Recorder 6.
I am stuck on the following error;

Exception occurred in application Recorder 6 at 02/07/2007 19:10:48.
Version : 6.7.2.77

Exception path:
EOleException : String or binary data would be truncated
Blah blah.

What does this mean and how can I mend it?

Thank you, best wishes,

Lizzy Peat
HBIC

Lizzy Peat's Website

2 Reply by davec (edited by davec 03-07-2007 08:02:39)

  • davec
  • Veteran
  • Offline
  • From: Brecon, Powys, Wales
  • Registered: 11-05-2006
  • Posts: 108

Re: String or binary data would be truncated. .

I can't be 100% sure, but my guess is that one of the spreadsheet columns has a large amount of text in it and exceeds some predetermined limit in the import wizard (or the library code it links to).

I'm assuming excel does not give an error when you open the spreadsheet. Use the column format tool in excel to widen the columns to make the data fit. Then scan down to see if any are really long.

Hope this helps.

Dave Cope,
Biodiversity Technology Officer,
Biodiversity Information Service for Powys and Brecon Beacons National Park.

davec's Website

3 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: String or binary data would be truncated. .

I had a feeling this problem rang a bell...

http://forums.nbn.org.uk/viewtopic.php?pid=1232#p1232

:)

I've not checked to see if this has been fixed in 6.10, but issues related to column width should have been.

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

4 Reply by davec

  • davec
  • Veteran
  • Offline
  • From: Brecon, Powys, Wales
  • Registered: 11-05-2006
  • Posts: 108

Re: String or binary data would be truncated. .

charlesr wrote:

I had a feeling this problem rang a bell...

http://forums.nbn.org.uk/viewtopic.php?pid=1232#p1232

Oh yes...:P

Dave Cope,
Biodiversity Technology Officer,
Biodiversity Information Service for Powys and Brecon Beacons National Park.

davec's Website

5 Reply by Lizzy Peat

  • Lizzy Peat
  • Lizzy Peat
  • Member
  • Offline
  • From: Hampshire (HBIC)
  • Registered: 17-05-2006
  • Posts: 38

Re: String or binary data would be truncated. .

Ah ha, found it.

I had some trailing blanks in a few of the shorter comment cells,

thank you chaps,

Lizzy Peat
HBIC

Lizzy Peat's Website