>I have an existing table with records. What is the proper method to import text delimited data seperated by pipes? Would it be better to create a temporary table first? I am trying to create this process for users to be able to use this method over Terminal Services. So I figured a cursor would be better than temp table so that there would be no conflicts with directories and overwriting. However, I cannot get this data into a cursor. Please help!! Thanks!!
Like :
Steven Buchanan|Sales Manager|15
?
append from myText.txt type delimited with "" with character "|"
BTW cursor is better than table IMHO.
Cetin