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
IL PROTECTED]
Sent: Tuesday, July 15, 2003 2:43 AM
To: [EMAIL PROTECTED]
Subject: FW: Pulling large Microsoft SQL files into MySQL
Importance: High
-Original Message-
From: Rudolf Bekker
Sent: Monday, 14 July 2003 14:13
To: MySQL MailList ([EMAIL PROTECTED])
Subject: Pulling large Mi
-Original Message-
From: Rudolf Bekker
Sent: Monday, 14 July 2003 14:13
To: MySQL MailList ([EMAIL PROTECTED])
Subject: Pulling large Microsoft SQL files into MySQL
Importance: High
The MySQL manual mentions that one could specify the column and value separators and
the end of file
AIL PROTECTED]
Sent: Monday, July 14, 2003 5:13 AM
To: [EMAIL PROTECTED]
Subject: Pulling large Microsoft SQL files into MySQL
Importance: High
The MySQL manual mentions that one could specify the column and value
separators and the end of file marker explicitly in the LOAD DATA
statement.
I&
The MySQL manual mentions that one could specify the column and value separators and
the end of file marker explicitly in the LOAD DATA statement.
I'm looking for the syntax of this statement to import large data files (.txt)
originally exported from Microsoft SQL 7.
Example file:.
"Extra
