Hello Guys!
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.
