[thelist] MySQL to SQL server

Rick Turoczy Rick.Turoczy at prosight.com
Thu Jul 12 15:16:55 CDT 2001


Alice,

Could you potentially link to the MySQL data through Access or Excel via an
ODBC connection to extract the data?

Just a thought. No idea if it has any bearing in reality. :)

Hope that helps,
Rick

Rick Turoczy
Manager, Marketing Communications
ProSight, Inc. |  Portfolio management for technology leaders
http://www.prosight.com/go.asp?ID=10
rick.turoczy at prosight.com
p. 503.889.4882



-----Original Message-----
From: Alice Hendricks [mailto:alice at ctsg.com]
Sent: Thursday, July 12, 2001 1:10 PM
To: Thelist at Lists. Evolt. Org
Subject: [thelist] MySQL to SQL server



Hello-

Does anyone know how you can get data from a MySQL database to SQL server?
Apparently you can't export a csv file, you can only export a SQL script.
Unfortunately, the sql script it writes out can't simply be run because some
of
the values being inserted into varchar fields have apostrophe's in them,
thus causing a syntax error.

Thanks in advance, as usual,

Alice




More information about the thelist mailing list