You can do it with ODBC, DAO. If you hava ACCESS you can do it simpler. With
Access, just create a link to your text file. And also create a link to your
SQL database.  There is a very good wizard in access which helps you to make
links without even writing a code. You can connect Access and get data from
text like a normal table and insert it to SQL. This way is the easiest way ,
I know. Ofcourse you can do everything with Visual basic. Just check
connection strings in help. I use access to make my life easier while
programming.

Regards,

HAN

-----Özgün İleti-----
Kimden: meng jin yan <jymeng@y...>
Kime: professional vb <pro_vb@p...>
Tarih: 10 Mayıs 2000 Çar
amba 17:20
Konu: [pro_vb] Any way to let user select text file format when load text
file into Database


>I want to load text file data into database. I found the interface for
>defining text file format provided by SQL Server Data Transformation
>Service is quite good and would like to have such a feature in my VB
>application. Unfortunately, I don't know how to implement it easily. Does
>anybody know whether there is a component or DLL to let programmer to
>implement it ?
>
>Your support is greatly appreciated.
>
>Regards,
>
>Meng Jin Yan
>