Importing Text File to Database

[MattyBoy]

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

Sorry this kinda turned into a quesion back at you. I'm still using the DTS. I just call a stored procedure from vb(using ADO) that executes my DTS Package. Is there something incorrect about this?

thanks
--B

[MattyBoy]

No it is fine, but I need a package that I can change the properties depending on which server, database, text file path I need to change, I tried programmtically doing this but still ran into problems!