AnsweredAssumed Answered

How can I import data from one source into different tables?

Question asked by timraudies on Jun 11, 2018
Latest reply on Jun 13, 2018 by onefish

Importing Data from one Excel File in different Tables.


Hi everyone,


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"?