I am in desperate need for a method to import the contents of a text file into a SQL Server table, ideally needs to be as quick as the DTS, I have tried to use the com interface but it is not very friendly so would like to use ADO, but need to know the optimun way of using it!!
If anyone can help I would be very happy!

Cheers