Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Append to existing Access went wrong

EG_GBM
7 - Meteor

I needed to append a 10-field Access data  to an existing Access sheet, but error shows below, How can I fix it? Thanks in advance to the people who helped me.

 

Error: 输出数据 (81): DataWrap2OleDb::SendBatch:Microsoft Access Database Engine: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.\3163 = -68551703
Insert into `Report`(`Transaction_Start`,`Transaction_End`,`Process_Name`,`Workflow_Name`,`Time_Saving`,`Transaction_Volume`,`Tool`,`Successful`,`Machine_Name`,`Account_Name`) Values (?,?,?,?,?,?,?,?,?,?)

 

My settings are as follows:

EG_GBM_3-1663064337321.png

 

EG_GBM_2-1663064035016.png

 

 

1 REPLY 1
grazitti_sapna
17 - Castor

@EG_GBM , With respect to the details you shared, it seems the error is you are loading the data to the field whose length is smaller than the data being loaded. Can you check once if there is any field which has length less than the data being loaded.

Sapna Gupta
Labels