When I use OpenRowset method to export data to Excel file, only 255
characters of columns are copied. How do I make it to copy all
characters?

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\test.xls;',
'SELECT * FROM [SheetName$]') select * from TableName

Madhivanan

Help! Need assistance!
Surrogate Keys
select only first row
scramble password
UPDLOCK problem with Stack