loadind excel data from remote server

[#1]

Hello All,

I am new to QV, I have to load data from excel file from remote server, How can I do that. Any help is highly appreciated.

fro example I have my excel file sitting in

[\\servername\Sample\new\ReferenceFiles\employeedata.xlsx]

[Gysbert_Wassenaar]

No problem. You can use UNC paths as file paths.

Data:

LOAD X, Y, Z

FROM [\\servername\Sample\new\ReferenceFiles\employeedata.xlsx] (ooxml, embedded labels, table is Sheet1);

Just make sure you actually have access to the excel file. And if you deploy your document on a Qlikview Server make sure the service account used to reload the documents has access to that file too.