I’ve tried to use the import table feature on mysql workbench to transfer csv excel files into mysql workbench but my files appear to be too large to import, it’s stuck for hours and eventually fails (see picture). I’ve even tried using xampp myphpadmin, but it times out even though I’ve amended the processing seconds to hours!

I need to be able to bring in data into sql workbench that’s more than 1,048,576 rowa which is the limit on excel. Anyone got any ideas on another way I can import data fast?

(I’ve tried the load data in file option too, but it’s not worked, not sure if I am doing this wrong, but open to suggestions)

Thanks in advance.