![Avatar of Squadless](https://cdn.experts-exchange.com/images/experts-exchange/avatar-01-large.gif)
Squadless
asked on
How to upload excel files into mysql DB
Hi,
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.
Thanks
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.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
![Avatar of PranjalShah](https://cdn.experts-exchange.com/images/experts-exchange/avatar-01-large.gif)
I am not familiar with Java but here is something i found online..
http://www.javazoom.net/jzservlets/uploadbean/uploadbean.html
Or you can post this question in Java Zone.
http://www.javazoom.net/jzservlets/uploadbean/uploadbean.html
Or you can post this question in Java Zone.
![Avatar of Squadless](https://cdn.experts-exchange.com/images/experts-exchange/avatar-01-large.gif)
ASKER
Thanks!, i would like to stay away from using a language to help me out. maybe something similar to "load data infile" or a derivative of it..
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER