I would like to import data from a text file into an SQL Server 7.0 table,
through a vb6 application. I already know how to import data from aonther
table (samples are given with SQL Server), but how should I do that for a
text file ?

Thanks

Olivier

With ODBC and DTS

This sounds like a case for BULK INSERT rather than DTS, but I believe you can
also do it throuh pure DTS programming.  I haven't tried it, but can't you use
the simple OLE DB provider?  or maybe the flat file provider?

--
Peter Daniels
Husband, Database Jedi, Avs fan