I have a simple text file which has more than 4000 characters in one column.
With the Import feature (Locale = English(United States), Unicode - Unchecked, Code Page = 1252 (ANSI Latin I),
I can only get 4000 in a column, even though the Destination Column is defined as varchar(max).
The problem is that the Source Input Column has to be defined in the importer wizard, and the only 'max' Source setting in the importer appears to be 4000 max. There's no varchar(max) setting for the Source Column in the importer.
Anyone have any ideas????:hehe:
thx
f