Error of max length of string using sql DTC to import DATA

Hi,

I am trying to use DTC to import about 500 records from an Excelsheet to an SQL database.

Some fields contain strings with a length of about 1700 characters.

When i'm trying to execute the DTC generated code it is giving an error and saying that the maximum string length of 255 has been reached. Althoug the column in the database is defined as nchar(1750).

Does anybody know an answer to this problem ?

Thanks in advance,

Goofythe max length of 255 is probably referring to the max length of text in a spreadsheet cell.

i know when i export to excel, all cell text gets clipped at 255 characters.|||Hi Thanks for your suggestion.

But till now no succes. I tried using .CSV as import type but still the same problem. Also if i use HTML as input type although the complete text (1700 char) is between the <DATA> and </DATA> tags.

Anybody with other suggestions ?