Question: how to import mysql data into sql server?
Answer: Open your ODBC Data Source Administrator from the Control Panel -> Administrative Tools. ... 
In the next dialog enter your MySQL server connection details, test it and click OK.
Set SQL_MODE to ANSI_QUOTES on MySQL Server.
Launch the SQL Server Management Studio.
Create a new database or use an existing database.