Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Canada
    Posts
    10

    Unanswered: trying to Import text file into MySql using VB 6.0

    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.
    Thanks in advance
    Devinder

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: trying to Import text file into MySql using VB 6.0

    Originally posted by Devinder Gera
    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
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •