Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have multiple xlsb format files and I want to load all of them in a single table. I have created ODBC connection but I can not find similar thread on how to load multiple files in single table.
Kaushik.solanki I just see your threads regarding the xlsb format issue. Do you have any idea about this.?
Thank you in advance.
Great solution as I am loading xlsb files from SharePoint folders and have complexities around connections thrown in for good measure.
One thing that caught me for a while was the SELECT/SQL statement was failing. I was using dymanic file names and the apostrophes around the file name and sheet name were the wrong apostrophe.
I was using ' but needs to be ` - chr(96) rather than chr(39).
Hope this saves someone else the hour or so I spent trying to sort it!
Hi
You can load the .xlsb files through sharepoint 0365 connectors (QlikWebConnector )
Load *
From [<sharepoint connector>]
(txt, utf8, embedded labels, delimiter is '\t', msq);
the part "(txt, utf8, embedded labels, delimiter is '\t', msq);" will be same as the file is loaded in the .csv format.