Hi All,

I am tryig to import a text file in to MySQL table using visual basic, but so far i have no success in it. Any kind of help will be appericiated.
I am using DTS packages to import data into SQL Server is there any way we can use DTS packages to import text file in MySQL(by changing connection properties) I tried my best to set connection properties for MySQL like connection provider to MySQLprov etc, but no success in that.

Thanks for your time.

You can use odbc in your package to connecte to your MySql Server.

You can also use LOAD DATA. It 's a better way to import large text delimited files in mysql

See

http://www.lasso-developpeur.net/us/...tab=db&lang=us