• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Bear Bibeault
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Jj Roberts
  • Carey Brown
Bartenders:
  • salvin francis
  • Frits Walraven
  • Piet Souris

Upload Excel data into MySQL Server (Remotely access)

 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
How to upload excel sheet into MySQL Server (remotely).

I have three column

*Client Name
*Date
*Message

and have 10 row approx.


how can I do that with python, VBA and JSP.
 
Saloon Keeper
Posts: 6802
162
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What part are you having problems with, specifically - uploading a file, extracting data from a spreadsheet, or saving to the DB? What do you have so far?

Since you mention JSP, I'm assuming this is a Java web app, where this kind of thing would be done in a servlet or similar. So what do VBA or Python have to do with it?
 
Aneeket Bhatnagar
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have a excel file where I have 20 row or 3+ column, I need this file upload into MySQL database.

I used java script for fetch data from excel in show into html now I tried to convert html table data upload into MySQL Database,
 
Aneeket Bhatnagar
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
 
Tim Moores
Saloon Keeper
Posts: 6802
162
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
OK, so no VBA or Python are involved at all.

If this was my problem, I'd upload the file to the server, use Apache POI to extract the data, and then JDBC to store it in the DB. Javascript can't do that last part anyway, so you need server code in any case.
 
No matter. Try again. Fail again. Fail better. This time, do it with this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic