XLSB file data retrieval: Urgent

[#1]

Hello Community,

I need urgent help on issue related to XLSB file format. Below are the details:

1) Connection to XLSB file at Sharepoint: DONE

OLEDB CONNECT32 To [Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;database=$(vSharepoint_Time_Booking_Data);Extended Properties="Excel 12.0;HDR=YES;"];

where vSharepoint_Time_Booking_Data = http://<servername>/sites/<>/<>/<>/<>/Time Booking Data.xlsb

It shows connected in the script execution.

2) Fetch data from the file, having only one sheet named as 'Project time booking' : NEED HELP

gwassenaar‌

swuehl‌

jagan‌

maxgro‌

tresesco‌ and all other geeks!!

Thanks

itsangad

[petter]

[#3]

Thanks Petter!

I think first option will be the best bet for me. Can you please help me download the correct .exe file?

There are many versions available at the site and it downloaded as XZ file.

Thanks in advance!

Thanks

[petter]

The one i ticked with a red dot would be the quickest to get started with - it's in a ZIP-file and only one file curl.exe:

[#5]

Hey Petter,

I used:
EXECUTE F:\Downloads\curl_4\curl.exe -O //<server>/<>/<>/<>/<>/<>/Time%20Booking%20Data.xlsb;

This shows DONE in the script execution.

Now how should I connect to the xlsb sheet named "Project time booking" ?

Thanks,

Angad

[petter]

Check if you have a file name like the XLSB file in the current directory:

        Time.......xlsb

Or it might be safer to explicitly name the directory and name of the file:

EXECUTE f:\downloads\curl_4\curl.exe -o f:\download\myfile.xlsb    h t t p : // server / ..... / ....xlsb ;

Place the cursor in an empty line after the EXECUTE and make sure that you already have the connect

statement in place pointing to c:\downloads\myfile.xlsb.

Then you use the SELECT wizard to help you get a valid generated load statement.

[petter]

[#8]

After scanning almost every article at google and researching, I dropped the idea of directly hitting the Sharepoint for XLSB file format.

I have asked the concerned team to download the file from sharepoint to my server location and then using it using ODBC or OLEDB connection.

Thanks,

Angad

[petter · Accepted solution]

Yes - getting support from other resources let you focus on your really value-added solution develolpment.