This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm using a solution in Alteryx Designer and the output is a MS Excel file with Excel (.xlsx) with Overwrite Sheet (Drop) selection.
I need to change it to MS Excel Legacy (.xlsx) format in order to allow the solution to use the Delete Data & Append so I can use the existing layout at the Excel file.
But I've encoutered several errors with the MS Access DB, the first one was referred as:
Error: Output Data (3): Error creating table "table_name": Microsoft Access Database Engine: Invalid precision for decimal data type.\3700 = -99878389 CREATE TABLE...
I've changed the data type from Fixed Decimal to Double and it didn't worked, it showed another error:
Error: Output Data (3): DataWrap2OleDb::SendBatch: Microsoft Access Database Engine: Operação OLE DB de várias etapas gerou erros. Verifique cada valor de status OLE DB. Nada foi executado. Insert into `sheet_name`...
Note: My MS Office main language is PT-BR
I've reinstalled the MS Access 2010 (Version 14.0.7015.1000) 64 bits and it still didn't worked and showed up the same error.
Did anyone experienced the same or a similar issue? So far I didn't found a solution for it.