Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rcqlik
New Contributor II

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

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.

2 Replies
Partner
Partner

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

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

Work smarter, not harder
MVP & Luminary
MVP & Luminary

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

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