Forum Discussion
Importi ng Multiple CSV/Excel files.
Hello all, I have a folder that has 5 distinct csv files. THese 5 files are 5 different tables so i do not wish to combine/merge them. How do I import them as 5 different tables? I connected the...
You mentioned that every table has different structure - so you have to edit every query manually anyway...
That would be for any transformation that Iwould have to do right. Here it would only be to load it as table. If you know a way out then kindly suggest,
Loading it as a table is a transformation. As each file is different the name and structure of the table(s) in the file will/can be different. So the process of 'simply' loading the table from a file will be different for each file.
Phil
