Importing Data from one Excel File in different Tables.
I am trying to import some records into my file. It is a list of products with different attributes.
I have an Excel-File with all the different fields in it, including the prices in 4 different currencies.
The problem is, that I am trying to store the 4 different prices in a separate table "Currencies" with the two fields "Currency" and "Price" in it, in order to reflect the "One Product can have Multiple Prices" relationship. Therefore I will need 4 records in this table for each record in the "Products" table.
How can I import the different prices to the table "Currencies"?