READING TEXT FILES

[itsmarkdavies]

I NEED TO READ A TEXT FILE INTO A SQL SERVER 6.5 TABLE. THE FILE HAS VARIABLE LENGTH FIELDS AND THE FIELDS ARE SEPARATED BY PLUS SIGNS ("+&quot. ANY IDEAS ? THANKS FOR YOUR TIME.

 

[tlbroadbent]

Use BCP. There is a commnad line option for the field delimiter. See you documentation, SQL Books Online, for details of SQL 6.5 BCP. I only have documents for SQL 7 and 2000 but I think the parameter is the same.

Example:
-t + Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.