Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.