Problem importing data into a TEXT field
I have a table with 30 fields in it, most of them varchar(50). In that table I have 3 fields that area TEXT datatype. I am trying to import about 1200 records from a flat file. I have tried to import using Excel, CSV, and Tab Delimited.
The problem is every time I do it, my three TEXT fields are being truncated to 255 characters. The largest number of characters I have in any of those three fields is ~7500.
Any ideas?
|
