Issue using Excel with DB activities

Help
1

Hi there,

I’m having trouble using connect/disconnect/non query with excel db (using ACE OLEDB 12.0).

I have this excel db with my transaction items that I try to update with the item status.
My code seems to work for a while (let’s say a week), then it stops registering information on my excel db.

To fix it I had to open the file, save any changes (I don’t even remember if I do change anything) and close again. Then the bot started to work properly.

Since it is happened a couple of time until now, I would like to know if is there any known issue about that (may be some character I have to avoid to insert? or stuff like that)

Thank you for your help
Giuseppe