I want to import some data from a Excel file into a Table the table has some values like
PArticipant ID
Iteration ID
Part ID
Measurement ID
Actual Value
The excel file contains all the info. Now when I want to put the values in the database, I have to fill all the above entries in the table by which the data will be identified. Entries like participan ID, iteration ID appear only once in the excel file but have to go in the table along with each "Actual Value" so that its complete. Can someone tell me the simplest way to do this