Below is a high level overview:
Use a Data Import Definition. The Destination Table field is the table you want to import into
The two most common Source Types are Header (the header of your spreadsheet) and Constant (“hard-coded” values)
The Source Field equates to the values being imported
- If Source Type is Header, then what you enter into the row should match to your spreadsheet exactly
- If Source Type is Constant, then what you enter into the row will be imported for every record
The Destination Field is the actual field name on the table you are importing into
Example Below:
