LOAD DATA INFILE '/oas/RealMedia/ads/OpenAd/./Reports/2010-12/01/rCam.db' IGNORE INTO TABLE rCam FIELDS TERMINATED BY '^' IGNORE 1 LINES (Account,Campaign,Impressions,Clickthrus,RmWhen)