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