Hi,

Would anyone be so kind and point me in the rigth direction?

I have a MYSQL server and a MSSQL 2000 server.

MYSQL
Database name is Membership
Table is Users
Column is email_address.

I want to transfer the email_address data over to a column in an
existing MSSQL Database.

When I run the DTS wizard I can successfully connect to the MYSQL
database server, but the only option I get is to use a SQL Statement.
So this is what I have started with...

mysql_select_db('membership');
SELECT * FROM users WHERE email_address='"*"

If i try and preview I get an unexpected errror and if i run through
the wizard I get wrong systax at line 1.

I am a total novice at this and am stumbling around in the dark...

Any help much appreciated...

Thanks
Col