We have one Excel file with data that needs to be uploaded every month. In my database there are two separate tables (Table A and TAble B) that I need to split that data from that one Excel file and load into the correct table in SQL.

For Example:

From Excel my columons are:

Version

Project_Code

Project_Name

Contract_Type

Hosting_CV,

OOP_Budget,

Non_Media_Pass,

Media_Pass

SEM_Budget

Business_Unit

Level

Billable_Hours

Non_Billable_Hours

Employee_Hours

Hourly_Rate,

Cost_Rate,

Rack_Rate

But I only need the data from the coloumns below to be inserted into Table A

Version

Project_Code

Project_Name

Contract_Type

Hosting_CV,

OOP_Budget,

Non_Media_Pass,

Media_Pass

SEM_Budget

And these need to go into Table B

Business_Unit

Level

Billable_Hours

Non_Billable_Hours

Employee_Hours

Hourly_Rate,

Cost_Rate,

Rack_Rate

One of the things I'm having a time working out is how to I get the data from that one excel file and split (or break) that out and insert the needed data into either Table A or Table B.

Regards,

D