Below is my target table and data should be inserted like below.

Date RepCurr Earning

1/1/2010CAD1.0520

1/1/2010CZK18.3475

1/1/2010EUR0.6977

1/2/2010CAD1.0532

1/2/2010CZK18.3985

1/2/2010EUR0.6957

1/3/2010CAD1.0517

1/3/2010CZK18.3360

1/3/2010EUR0.6982

1/4/2010CAD1.0377

1/4/2010CZK18.1624

1/4/2010EUR0.6935

1/5/2010CAD1.0371

1/5/2010CZK18.2541

1/5/2010EUR0.6943

1/1/2010USD0.9506

1/1/2010USD0.0545

1/1/2010USD1.4333

1/2/2010USD0.9495

1/2/2010USD0.0544

1/2/2010USD1.4374

1/3/2010USD0.9508

1/3/2010USD0.0545

1/3/2010USD1.4323

1/4/2010USD0.9637

1/4/2010USD0.0551

1/4/2010USD1.4420

1/5/2010USD0.9642

1/5/2010USD0.0548

1/5/2010USD1.4403

Thanks in Advance!!!