Is it better to use LOAD or to use ODBC to read Excel file?

[rcqlik]

As per title, is it better to use LOAD statement to read Excel file, or to use ODBC and SQL select statement to load my Excel file?

I need to process the data, by adding new fields to the resulting table, and also to perform INNER JOIN (like in SQL) between multiple Excel files.

[JordyWegman]

Hi Rc,

You can use both, but you will have different sources while the first will be in a normal folder and the other one in maybe a database. 

If it's just a normal folder structure, use the 'LOAD / FROM'. 

Jordy

Climber

[marcus_sommer]

Probably there is no general benefit of one approach against the other else it will depend to your requirements which method might be more suitable in your case. Personally I use the load-approach because it is much simpler and only if there are special requirements like unknown sheetnames or xlsb-files I use odbc.

- Marcus