I am struggling with the syntax on how to do the following:
Load TableA with 3 data fields from 4 differnet Excel files. The data is indentical in every file, but the field name to which the last data field from the Excel files gets loaded needs to be different, depending on which Excel file is being read at the time.
so:
pseudo code:
for each file in list
load fieldA as "A",
fieldB as"B",
fieldC as "what goes here? it depends on the name of the file"
any ideas?
thanks.
