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
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:  http://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.
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

Login/Register to Answer

Related Questions