I searched the topics and see one or two questions like this one, but not the answers.
I have a .csv file which is stored on sharepoint (with headers)
I want to read the csv file to a datatable. In the MS 365 package there is nothing for .csv files. As i am running not running in the cloud ik have no sharepoint activity option available And I cannot store locally so I cannot download the file first (which of course would also be time consuming)
How to read the data from this .csv into a datatable?
why not download file?
download file can still work on cloud and then can use read csv
office 365 package has the option to download file and it is not very slow
cheers
There is an inhibit on downloading files so I would likely have to use a less secure location. But it also seems like a workaround. Of course if there is no other way, I could go with storing as Excel files or downloading the .csv. But primary I would want to eliminate steps (converting or downloading) for something that should actually be so simple as to read data from a textfile in .csv format. But like I found, lots of topics, but never a solution.
Is it simply not possible? I can’t really believe that.