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