Output to xlsb using append to existing sheet - Error could not find the object

[Karenwonder]

Hi there,

I am trying to output my data to .xlsb on a sheet called "TESTA" using the append to existing sheet option. 

I keep getting the error of: 

Error: Output Data (8): Error opening query: Microsoft Access Database Engine: The Microsoft Access database engine could not find the object 'TESTA'. Make sure the object exists and that you spell its name and the path name correctly. If 'TESTA' is not a local object, check your network connection or contact the server administrator.\3011 = -543884569

I have the database engine 2010 installed and tried the solution to add $, so it becomes "TESTA$". Unfortunately still no luck to have it fixed. If I use exactly same sheet, only change from xlsb to xlsx, everything will be working as expected.

Any help is appreciated.

Cheers.

[BrandonB]

Hi @Karenwonder 

What happens if you choose the "Create New Sheet" option and run it again? Does it successfully create a sheet in the XLSB file? 

[Karenwonder]

Hi Brandon, 

yes, the create new sheet works, it is only the append to existing does not work.

Any insight would be appreciated.

Cheers,

Karen

[ArtApa]

Hi @Karenwonder - This is weird. Would you like to update your MS Access DB Engine? Here is the link: https://www.microsoft.com/en-au/download/details.aspx?id=13255 

[BrandonB]

If you do a create a new sheet, run the workflow, and then change it to append for the second run does it work? 

[Karenwonder]

Hi Brandon,

I followed your steps to first create new sheet (successful), second run append to that new sheet.

I get error: 

Error: Output Data (8): InboundNamedPipe GetOverlappedResult:  The pipe has been ended.

I tried using TestBinary$, same error was given. Could it be something related to the driver? 

This is the one I have installed. Thank you very much.

 

[BrandonB]

It could be driver related, but it does seem like you have the access driver installed: https://www.microsoft.com/en-us/download/details.aspx?id=13255 

Can you send an email to support@alteryx.com so that our support team can take a deeper dive into the error? 

[vbmike73]

Has this ever been resolved? I'm having the same issue with Append.

[akmuthu]

Is this issue resolved? I'm having the same issue.