Automate the Excel file data upload to MySql server table

Question

1.00/5 (1 vote)

See more:

Hi,

I need to upload the excel file data into mysql server database tables. Need to automate this process using the scripts. The script should pick the file from the location and should validate the data in the excel and insert the data into the mysql table.

Can anyone help me in this regard.

Posted 26-Jun-14 9:47am

Hithesh Reddy

Add a Solution

Comments

[no name] 26-Jun-14 15:54pm

Help you with what? You say "the script" like we would know what you are talking about. Is what you have written a script? C#? VB.NET? What is the problem with the code that you have written?

ZurdoDev 26-Jun-14 21:37pm

Script can't automatically grab files off of a client computer. The user has to select. Otherwise, that's a huge security issue.

What's your actual question?

Prasad Avunoori 27-Jun-14 2:07am

Do you want MySql Script?

Hithesh Reddy 27-Jun-14 15:06pm

Yes, i need a MySql Script which picks the data from the excel sheet and then inserts into the database. The excel file will be placed in the local sever and then the script should pick the file from that location, then validate the data and then insert into DB.

As I am new to SQL scripts, I have no idea how to begin with. It would be great help if anyone could help me out in this regard.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)