Thank you guys for responding.

The spreadsheet has 160 columns with one row for each column. The destination table has a primary key called "ID" which is not on the spreadsheet.

The 1st step is to get the "ID" from another table where the columnname matches the columnname on the spreadsheet.

The 2nd step is to insert the "ID" and the value of each column to the destination table.

How can I achieve this?

Thank you!