Skip to main content
Answer

Inserting data into Excel error of "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."

  • November 20, 2023
  • 1 reply
  • 126 views

Forum|alt.badge.img+4

When I try to use Database command of “Insert into” an Excel file. I get the following error:

“The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.”

 

How can i solve this issue. Kindly help. !!!

Best answer by Sajith Sudhakaran

Hello @Faiz Khan Please review the following KB article where the similar issue is documented along with resolution.

https://apeople.automationanywhere.com/s/article/Error-inserting-huge-data-into-Excel-using-Excel-as-database

https://apeople.automationanywhere.com/s/article/Unable-to-Add-excel-data-from-Read-from-CSV-file-command

1 reply

Forum|alt.badge.img+8
  • Automation Anywhere Team
  • Answer
  • November 21, 2023