I have a bunch of excel files that I would like to upload into one table in mysql db. Every row would have an assigned ID (primary key) and a second column (the excel sheet in binary format?). How can i do this?
I have Navicat 8 for mySql and i have MySql workbench. I cant find an import option where i can do this. I can import a spreadsheet as a table or into a table but what i primarily want to do is to store the entire spreadsheet as binary format or whichever format is possible so that it only takes up one cell in the table.