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)
 large data field

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-28 : 08:21:21
Verghese writes "Hi everyone,

I have a large text file that I receive evereyday that I need to import into a SQL server database. One of the fields in this text file is over 8000 charcaters long. It is a combination of id, text and values that needs to be parsed out. I have tried importing that field into a SQL server table as a text field data type, but the problem then seems to be that I cant do anything with that data type.

Any help will be greatly appreciated

Thanks"
   

- Advertisement -