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:
Solved! Go to Solution.
@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.