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

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by Jose D Dunn
Go To Solution
Answered By 40 points N/A #152288

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

qa-featured

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
Best Answer
Best Answer
Answered By 10 points N/A #152289

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

qa-featured

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

How to manage multiuser chat application ppt?

Previous

Further information about juniper training lab

Next

Related Questions