Hi - I have been importing excel results into Bus Obj without any issues until now - I am getting a message ‘‘The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data’’
Any help would be greatly appreciated
PhilB (BOB member since 2008-02-28)
How many columns are there in your Excel? What is the version of Business Objects you are using?
Are there any column in Excel has large value? What is the version of MS-Office?
Sree Konduri (BOB member since 2005-07-14)
6 columns
Business Objects 5
Microsoft 97
When you refer to large value - do you mean characters?
Cheers
PhilB (BOB member since 2008-02-28)
the max field size for excel is 255 characters. If you are exceeding this, you’ll need to truncate the field, or split it into multiple fields/columns. You can do this with the substr() function.
For example:
For the first column, create a formula field with the following:
substr([Field Name];0;255)
For the second column, create a formula field with the following:
substr([Field Name];256;511)
If you need to split it up further, just start with 512 for the first number and add 255 to it for the second number. Basically, you’re creating a 255 character column each time you do this. Also, your data has to be a string value.
Ruune 
(BOB member since 2007-08-13)