Hello,
I’m trying to import table data from an excel/csv file. I noticed there is a Generic Excel Driver. It has no description but by the name, it sounds like it imports excel sheet data.
The excel file I want to import is local. I tried putting the full path to the file under ‘Data Source’ in the General Settings of the Generic Excel Driver but the ‘Query Status’ is ‘Fail’.
This is the file path I used (C:\Users\skyline\Desktop\Skyline\SINGLE.xls). Am I putting the correct path or is there a root directory?
Am I off base with what this driver does?
Thanks,
Hi,
I don’t have any experience with the Generic Excel driver myself. However, to import a file via an element, the file will need to be available on the DataMiner server itself (or via a network path).
The easiest way to do this would be to add the file to the Documents (via DataMiner Cube) and then the file should be available on the DataMiner server itself via “C:\Skyline DataMiner\Documents\[additional folders you created]\[file name].[extension]”. More info on the Documents module can be found in the help.
Can you give this a try?
Thanks for your suggestion. I added the file via the Documents. It makes the excel sheet available on Dataminer. However, I was looking more for making the table within the excel sheet available as a table in Dataminer.
For now, I’ve been given a driver to manual enter data. It’s getting me off the ground.