[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