Hi:
Or you can use a DTS to transfer the info to MySQL
Greetings
From: "Ralph Guzman" <[EMAIL PROTECTED]>
To: "'Rudolf Bekker'" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: Pulling large Microsoft SQL files into MySQL
Date: Tue, 15 Ju
LOAD DATA INFILE "data.txt" INTO TABLE table_name FIELDS TERMINATED BY
'|' ENCLOSED BY '"' LINES TERMINATED BY '\n';
You can find more on this at:
http://www.mysql.com/doc/en/LOAD_DATA.html
-Original Message-
From: Rudolf Bekker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 2:
LOAD DATA INFILE "data.txt" INTO TABLE table_name FIELDS TERMINATED BY
'|' ENCLOSED BY '"' LINES TERMINATED BY '\n';
You can find more on this at:
http://www.mysql.com/doc/en/LOAD_DATA.html
-Original Message-
From: Rudolf Bekker [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 5:13