Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Select Excel Data greater than 255 characters

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-11-21 : 08:10:42
Lokendra writes "Plz describe me with Example that How Do I select the Excel Sheet Data which is more than 255 characters in SQl Server.
OPENROWSET or OpenDataSource options can select the Excel Data but if the Excel Data is Greater than 255 character then It is truncates. So how can I select the data using query in Query Analyzer, not By DTS fascility.
Thanks"
   

- Advertisement -