Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Posts
    18

    Unanswered: help me!!!how to write such sql in mysql?

    in sql: insert into table select from ...
    can select from a remote data base server such as sqlserver using odbc
    as 'SELECT * into test01 FROM Fund IN [ODBC] [ODBC;Driver=SQL
    Server;UID=admin;PWD=;Server=(lacal);DataBase=CMBX MDM;]'in access.
    thanks!

  2. #2
    Join Date
    Oct 2003
    Posts
    706

    Question

    It sounds to me like you are trying to insert data from an MS-SQL Server database into a MySQL database but your post is really not clear.

    If you are using MS-Access to do the job then you can set up two ODBC connections, one to the MS-SQL data and the other to MySQL, then use MS-Access queries to move the data from one source to the other.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  3. #3
    Join Date
    Dec 2003
    Posts
    18
    sorry,my problem is not be expressed clearly.indeed ,I am trying to insert data from an MS-SQL Server database into a MySQL database ,MS-SQL use odbc or ado
    but Mysql I use embedded mysql so i don't if i can insert data from a remote MS-SQL Server database into a embedded MySQL database in batch.
    samely like 'insert into test01 selcct FROM Fund IN [ODBC] [ODBC;Driver=SQL Server;UID=admin;PWD=;Server=lacal);DataBase=CMBX
    MDM;]' can i realize it ? thanks!

  4. #4
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    Why did you not use a dts package to perform this task
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  5. #5
    Join Date
    Dec 2003
    Posts
    18
    what is dts?

  6. #6
    Join Date
    Dec 2003
    Posts
    18
    i used embedded mysql
    i want to realize conviting data from sqlserver to mysql in my program

Posting Permissions

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