hello there,
i'm trying to import mysql .sql extension file into sql2k
to create the table but looks like sql2k does not support
direct import of mysql data file. here are the contents of
the file .
============================================
#
# Table structure for table 'analyst'
#

DROP TABLE IF EXISTS analyst;
CREATE TABLE analyst (
Analyst_No smallint(6) default NULL,
Analyst_First_Name text,
Analyst_Last_Name text,
Analyst_Description text,
Analys_Approval tinyint(1) default NULL
) TYPE=MyISAM;

#
# Dumping data for table 'analyst'
#

LOCK TABLES analyst WRITE;
INSERT INTO analyst VALUES (0,'O.B.',NULL,'Analyst Not
defined',0),(1,'Ron','XYZ','Director ',1),
(2,'Hervé','Guy','Quebec',0),(3,'René','Hatem','CA NADA',0),
(4,'Bryan','Drummond','Ontario',0),
(5,'Ted','Paull','Ontario',0),
(6,'Peter','Fili','Canada',0),
(7,'J.F.','Hamelin','Canada',0),(8,'Dany','Long',' Quebec,
Atlantic Canada ',0),(9,'J.F.','Jolin','Quebec',0);
UNLOCK TABLES;
==========================================
is there any way to import a file with this format without
making any changes as it's a big file.

sqlserver does't like the comments in the file also some
of the datatypes are not supported.


thanx
Asif

would you recomend that ...
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/iis/iis5/deploy/depovg/mysql.asp

I know data types are not compatible but would it work ?