Dynamic Input - Loading XLSB file Error as Target file may be corrupt

[Sri9]

Any solution in this is much appreciated?

I am not able to open XLSB file in Dynamic Input tool. Dynamic Input (16) Target Excel file may be corrupt! Cannot find required file, or element within file: xl/workbook.xml

[BrandonB]

Do you already have this driver installed to read in xlsb files? https://www.microsoft.com/en-us/download/details.aspx?id=13255

This is a requirement to read xlsb files as seen on our data sources page: https://help.alteryx.com/current/designer/data-sources

[Sri9]

Yes, installed the driver and able to import XLSB on Input tool but from Dynamic Tool i am not able to import XLSB.

[BrandonB]

I wonder if a macro based approach might help you here. Take a look at the following article which has a macro you can use for bringing in multiple xlsb files: https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Exc...

[Sri9 · Accepted solution]

Finally got a solution from Alteryx Support

Plus the File path string should be 

[FilePath] +"|||"+ "`" + [SheetName] + "$`"

[BrandonB]

That will do the trick! Glad you got it figured out.

[Sri9]

Its loading fine if the file is in Temp or local PC. But, looks like if I load the file from SharePoint and Shared network drive i get error " Dynamic Input (30) Error opening table: Microsoft Access Database Engine: System resource exceeded.\3035 = -66192371. Any idea why?
"

[praneshsapmm]

Hi Sri9,

I have the same issue as you mentioned in this thread . In spite of all the steps followed , i still have the below issue . 

 Tool #1: Target Excel file may be corrupt! Cannot find required file, or element within file: xl/workbook.xml

Can you help . 

Full Path String : [FullPath]+"|||"+"Shee1"+"$"

Thanks
 

[Sri9]

Hi Pranesh,

PLease note after the $ symbol there is a ` added there.

[FilePath] +"|||"+ "`" + [SheetName] + "$`"

THanks

Sri9

---------------------------

Hi Sri9,

I have the same issue as you mentioned in this thread . In spite of all the steps followed , i still have the below issue . 

 Tool #1: Target Excel file may be corrupt! Cannot find required file, or element within file: xl/workbook.xml

Can you help . 

Full Path String : [FullPath]+"|||"+"Shee1"+"$"

Thanks

[praneshsapmm]

Hi ,

I tried this . Still the same issue. 

 Target Excel file may be corrupt! Cannot find required file, or element within file: xl/workbook.xml

Changed full path : [FullPath]+"|||"+ "`" + "Sheet1" + "$`"

Thanks.