Hi
I am trying to create a DTS package to import from an Excel spreadsheet. The spreadsheet has 8 columns which are greater than 255 characters and I am importing these into ntext fields. When creating the DTS package, it says all of the fields on the spreadsheet are varchar(255) except one that is longtext. Not sure if this is an Excel question but how do I make all of the other fields longtext as at the moment, when trying to run, it's telling me that the buffer size is exceeded?
Thanks
Chris
I am trying to create a DTS package to import from an Excel spreadsheet. The spreadsheet has 8 columns which are greater than 255 characters and I am importing these into ntext fields. When creating the DTS package, it says all of the fields on the spreadsheet are varchar(255) except one that is longtext. Not sure if this is an Excel question but how do I make all of the other fields longtext as at the moment, when trying to run, it's telling me that the buffer size is exceeded?
Thanks
Chris