Hi,
I'm trying to import data from an Excel spreadsheet.One of the fields in the spreadsheet is a comment field which is often greater than 255 characters.
On importing the data to SQL, this field concatenates at 255 chars. It doesn't matter whether I create the import table up-front with the field data type as text or whether I create a new table on import, the same happens.
Even if I create a tab-delimited text file from the spreadsheet, I get a row of #'s if the field is > 255 chars so it looks the same would happen with BCP.
I was wondering if anyone could shed any light as to how I could perform this data transfer effectively..
ta
Eddie
I'm trying to import data from an Excel spreadsheet.One of the fields in the spreadsheet is a comment field which is often greater than 255 characters.
On importing the data to SQL, this field concatenates at 255 chars. It doesn't matter whether I create the import table up-front with the field data type as text or whether I create a new table on import, the same happens.
Even if I create a tab-delimited text file from the spreadsheet, I get a row of #'s if the field is > 255 chars so it looks the same would happen with BCP.
I was wondering if anyone could shed any light as to how I could perform this data transfer effectively..
ta
Eddie