Description:
Importing a csv file (from excel) into an already created table.
testing I find I needed to edit a datetime field as it did not import the value.
I cancelled the import. and the error occurred.
Cannot access a disposed object.
Object name: '_ProgressBar'.
There was a corresponding output shown: DEALLOCATE PREPARE stmt OK
teh table was
mysql> explain power;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| numb | int | NO | PRI | NULL | auto_increment |
| dattime | datetime | YES | | NULL | |
| power | decimal(5,2) | YES | | NULL | |
+---------+--------------+------+-----+---------+----------------+
date to be imported was a dattime and power from the csv (32,506 lines)
Time,OPVoltage
20/03/2026 00:00,0
20/03/2026 00:01,0
20/03/2026 00:02,0
20/03/2026 00:03,0
20/03/2026 00:04,0
.......
.......
How to repeat:
create the target table.
import the table using the wizard in workbench,
cancel the task after realising the date is not structured correctly in the csv file.