Importing Text Files into SQL server 2000

[pinkpanther27]

I would like to find out how to import .txt files (delimited) into SQL Server 2002 without using DTS or BCP.

If anyone has any helpful hints and/or references to give they would be very much appreciated.

Thanks

Pink

 

[noren]

When I needed to do exactly what you need to do, I made my own parser with vb.net.

But dts is also possible, why don't you want to use it?