Pulling large Microsoft SQL files into MySQL

[Rudolf Bekker]

------_=_NextPart_001_01C34A01.33763174
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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.
=20
I'm looking for the syntax of this statement to import large data files =
(.txt) originally exported from Microsoft SQL 7.
=20
=20
Example file:.
=20
"Extract_Date"|"LAU"|"Customer_Number"|"BAN_Number "|"Telephone_Number"|"B=
ill_Date"|"Local_Usage_Credit_Amount"|"Local_Usage _Credit_Call_Count"|"Lo=
cal_Usage_Credit_Call_Seconds"|"National_Usage_Cre dit_Amount"|"National_U=
sage_Credit_Call_Count"|"National_Usage_Credit_Cal l_Seconds"|"Internation=
al_Usage_Credit_Amount"|"International_Usage_Credi t_Call_Count"|"Internat=
ional_Usage_Credit_Call_Seconds"|"Cell_Usage_Credi t_Amount"|"Cell_Usage_C=
redit_Call_Count"|"Cell_Usage_Credit_Call_Seconds" |"Other_Usage_Credit_Am=
ount"|"Other_Usage_Credit_Call_Count"|"Other_Usage _Credit_Call_Seconds"
"20030409"|"63"|"63000233"|"630002330001"|"--"|"200211"|"0"|"0"|"0"|"0"|"=
0"|"0"|"0"|"0"|"0"|"0"|"0"|"0"|"-555.94"|"0"|"0"
"20030409"|"63"|"63000233"|"630002330001"|"--"|"200302"|"0"|"0"|"0"|"0"|"=
0"|"0"|"0"|"0"|"0"|"0"|"0"|"0"|"-594.24"|"0"|"0"
"20030409"|"63"|"63000233"|"630002330001"|"--"|"200303"|"0"|"0"|"0"|"0"|"=
0"|"0"|"0"|"0"|"0"|"0"|"0"|"0"|"-615.21"|"0"|"0"
"20030409"|"63"|"63000235"|"630002350001"|"0539480 616"|"200201"|"-10.53"|=
"-14"|"-2346"|"-4.89"|"-6"|"-534"|"-1.3"|"-1"|"-26"|"-14.82"|"-4"|"-570"|=
"0"|"0"|"0"
"20030409"|"63"|"63000283"|"630002830001"|"0539480 627"|"200111"|"-6.14"|"=
-1"|"-7804"|"0"|"0"|"0"|"0"|"0"|"0"|"0"|"0"|"0"|"0"|"0"| "0"
"20030409"|"63"|"63000283"|"630002830001"|"0539480 627"|"200201"|"-140.79"=
|"-143"|"-101519"|"-68.16"|"-43"|"-9723"|"0"|"0"|"0"|"-5.68"|"-4"|"-240"|=
"0"|"0"|"0"
"20030409"|"63"|"63000421"|"630004210001"|"0539362 1802"|"200303"|"0"|"0"|=
"0"|"-128.27"|"-22"|"-4680"|"0"|"0"|"0"|"-39.65"|"-6"|"-840"|"0"|"0"|"0"
"20030409"|"63"|"63000459"|"630004590001"|"0539481 533"|"200302"|"0"|"0"|"=
0"|"0"|"0"|"0"|"0"|"0"|"0"|"-.01"|"0"|"0"|"0"|"0"|"0"
"20030409"|"63"|"63000495"|"630004950001"|"0539490 419"|"200302"|"0"|"0"|"=
0"|"0"|"0"|"0"|"0"|"0"|"0"|"-.02"|"0"|"0"|"0"|"0"|"0"
"20030409"|"63"|"63000519"|"630005190001"|"0539490 719"|"200302"|"0"|"0"|"=
0"|"0"|"0"|"0"|"0"|"0"|"0"|"-.01"|"0"|"0"|"0"|"0"|"0"
"20030409"|"63"|"63000521"|"630005210001"|"0539823 312"|"200111"|"0"|"0"|"=
0"|"-12.29"|"-5"|"-2100"|"-13.5"|"-1"|"-180"|"-264.15"|"-63"|"-17340"|"-3=
4.15"|"-19"|"-6360"
=20
I need to specify the text separator as " " and the column separator as =
|.
=20
=20
=20
Thanx,
=20
Rudolf.
=20

------_=_NextPart_001_01C34A01.33763174--