Link to home
Start Free TrialLog in
Avatar of Squadless
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
ASKER CERTIFIED SOLUTION
Avatar of PranjalShah
PranjalShah
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Squadless
Squadless

ASKER

I am actually using Java, any suggestions as to how to help with that?
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.
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
Avatar of Ron Malmstead
Ron Malmstead
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial