Hi Guys,

I have over 25 million records to import to a table. How ever the data is set out as the following:

WA2 8PR, Unit 3, Winstanly Ind Estate, Long Lane, Warrington, Cheshire,
SK11 8EQ, 1, Westbond Street,, Macclesfield, Cheshire
WN7 2HX 1, Wensleydale Road,, Leigh, Lancashire
I'm currently uploading the 1.88GB csv file to the server and going to be using the LOAD DATA query to do it, how ever what do i put to as Columns enclosed with and Columns escaped with? Also do i put Lines terminated with as /n ?

Thanks