Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connect MySQL to an different database through ODBC

Status
Not open for further replies.
KGT

KGT

Programmer
Mar 16, 2005
1
BE
Is it possible to make a statement where you can import selected tables from a different datasource?
Something like
INSERT INTO mysqltable
SELECT * FROM odbctable

Where "odbctable" connects through a connection string in de ODBC manager of Windows.
I know of a MySQL ODBC driver, but can MySQL communicate with ODBC itself on a Windows platform the other way around?

Thanks for your help!
 
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
277
EdZzy
E
eizs002
  • Locked
  • Question
Connect MS Access to mysqlDB without ODBC
Replies
3
Views
320
spamjim
spamjim
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
483
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
438
Chris Miller
Chris Miller
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
355
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top