June 11, 2002 at 1:51 pm
We have to insert data into a single column of NTEXT datatype, from an ASCII file. This has to be done using a sored proc or using a command prompt utility. I tried TEXTCOPY. But it works only on TEXT and not on NTEXT. It would be helpful if some one can give an idea?
June 11, 2002 at 2:19 pm
Havent had a use for TextCopy, didnt know it had that limitation. You can insert it into a working table as standard text, then move it to the final table, or build something using the ADO Stream object to process the files, probably along with the file system object.
Andy
June 11, 2002 at 3:06 pm
Thanks. That's a trick we can try. But I wonder there has to be something more straight forward.
As we need to automate the process, we have to use only a proc or command utility.
June 11, 2002 at 6:09 pm
No reason you can't code your own using ADO if you need it. Just put all the code in a module, support a couple command line params or an ini file or whatever, off you go!
Andy
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply