We help IT Professionals succeed at work.

Method to transfer data from Excel an online database without using VBA or Microsoft technologies

brohjoe
brohjoe asked
on
What is the most efficient method of transferring data from Excel to an online database without using VBA?  I've been trying to use VBA to transfer the data for the past three months with no success.  I heard there was a way to use POI to transfer the data.  Is that the best Java based method of doing this?
Comment
Watch Question

Top Expert 2016

Commented:
Try getting a JDBC driver connection to it
Mick BarryJava Developer
Top Expert 2010
Commented:
have a read here

http://www.javaworld.com/javaworld/javaqa/2002-05/01-qa-0503-excel3.html
http://www.javaworld.com/javaworld/jw-03-2004/jw-0322-poi.html

you could probably also export it as csv and import it into the database using whatever bulk loader app it provides
Commented:
Try using MySQL Migration Tool Kit.
You can transfer/migrate data from db to db systems.
Top Expert 2016
Commented:
Commented:
Thanks guys.
Top Expert 2016

Commented:
brohjoe, you should close the question by accepting multiple solutions if you're happy. See the help options