I was able to try this and used the SQL Server 2000 Enterprise Manager to
setup a Data Transformation Services process. Using the DTS (or DTS Import
Data) wizard, it automatically created a "ntext" data type for the column
that had more than 255 characters in it. Hope that helps.
John
--------------------
| Content-Class: urn:content-classes:message
| From: "Aaron Huang" <
[email protected]>
| Sender: "Aaron Huang" <
[email protected]>
| Subject: varchar(255) Problem!urgent!
| Date: Tue, 12 Aug 2003 00:10:09 -0700
| Lines: 5
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNgoMPP5JnoYwH0TSyRJb7y6Ppxlg==
| Newsgroups: microsoft.public.excel.misc
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.misc:264600
| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
| X-Tomcat-NG: microsoft.public.excel.misc
|
| I want to export data from excel sheet to sql
| server.There're some cells that have more than 255
| chars,with the extra-255 chars being truncated during the
| export to sql server.how to resolve this problem?thanks a
| lot!
|
