sqlloader & csv files

From: Simon Griffiths <s.griffiths_at_virgin.net>
Date: Thu, 25 Jun 1998 22:38:27 +0100
Message-ID: <3592C353.4E6D908A@virgin.net>

I've been sent a csv file produced from MS-Access which includes character fields
with embedded newlines. All fields are quoted.

What's the easiest way to load using sqlloader ?

Thanks,

simon.

File example (header + one data row)

---

Name,Address
"Simon","High Street,
Cardiff,
Wales,
UK"

---

Received on Thu Jun 25 1998 - 16:38:27 CDT