i just noticed that one of the fields I'm loading, does not have a field name in Excel (embedded header).To add to the above discussion, how can I dinamically give a field name (taken into consideration that all the other fields DO have embedded field names). I could put them in manually, but there are many files that I need to load.Thank you
Thank you Khaled, Problem is, I have multiple files in the subdirectory (and I dont always know how many). I would just like to load all the files that contain 'HIST' in the file extension....it might be 'HIST001' and 'HIST002'.
You can use wildcards to select from multiple files, similar to ...
@1 as Data1,
@2 as Data2
(txt, codepage is 1252, no labels, delimiter is '|', msq, header is 1 lines);
Regarding the missing field name, if you try to load it as embedded labels you will get an error due to the missing column identifier. If you say all the files are same structure, then load it with "no labels" and skip the first line (the header, shown as "header is 1 lines" above) and alias the fields such as @1 as Data1, @2 as Data2.