What is appropriate method to import csv JSP file into database?

Asked By Krueger Jim 0 points N/A Posted on - 04/02/2013

Hi guys,

I am using SQL server database and some results are saved in CSV file using JSP and now I want to import csv jsp format file into local database SQL Server for my web base application.

I have tried different SQL Query but none works. Changing Java code in jsp also fails to fulfill my choice.

Please help me how to import and use them in MYSQL database?

• Status: Open
• Question Views: 1182
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Jose D Dunn

Go To Solution

Answered By Michael D Dent 40 points N/A #152288

What is appropriate method to import csv JSP file into database?

Hello,

I found a good article which will show you how to accomplish what you need to do. Since this tutorial is very long, I won't post it here. You should check out this page to find more information:  https://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/.

 

This tutorial will explain to you everything you need to know in order to finish your task. Of course, this method is very easy to understand since it is written for beginners. I hope I helped.  Regards.

About Michael D Dent

Questions
18

Answers
101

Best Answers
36

• Vote Up 0 Vote Down

• Posted on - 04/22/2013
• Question Category: MySQL Server

Best Answer

Best Answer

Answered By Jose D Dunn 10 points N/A #152289

What is appropriate method to import csv JSP file into database?

Greetings Krueger Jim!

Here is the step-by-step process in importing CSV to SQL Server. First launched the SSMS and then you will be ask for a connection. Now find the MSSQLTipsSSISTutorial database in the SSMS Object Explorer. Right click the MSSQLTipsTutorial database and select Tasks, select Import Data from the context menu to launched the Import Wizard. Click next and then the Wizard will now let you choose the data source.

Click next, and choose Destination.

Click next and Specify Table Copy or Query.

Click next to Save and Execute Package.

Click next to proceed to Save SSIS Package.

Then again click next. The Complete Wizard dialog will show.

Click Finish and you can now view the imported table in SSMS.

Best regards,

Jose D Dunn

About Jose D Dunn

Questions
11

Answers
102

Best Answers
26

• Vote Up 0 Vote Down

• Posted on - 04/29/2013
• Question Category: MySQL Server