Excel allows to extract data from a wide variety of data sources (from a text files such as csv files, from SQL, MS Access and other ODBC/OLEDB compliant sources etc..). Thus, if you have issue to extract data using Qlikview/Qlik Sense, testing with Excel can help to check if the issue is related to Qlikview/Qlik Sense or simply a data source connectivity. Examples
The basic process is that you first identify the type of data source and then the location. Depending on the type of source, you’ll have appropriate options.
- Open a Microsoft Excel spreadsheet.
- From the Data menu >> choose Get External Data >> from other sources >> select appropiate options (ex: ODBC, OLEDB etc..)
For Ms Office 2007, 2010 -2013, click here
- In Select Data Source dialog box, select a data source /related drivers etc..
- If the database accessed by your data source includes tables, select a table.
- The data you selected is imported into your Microsoft Excel spreadsheet.
If you succeed in Excel, this should normally work for QliView as well.
if not you may need to fix a connectivity issue before fetching data in Qlikview Environements