CSV file to database

Question

hi how to load a Excel csv file into a database using SSIS iam trying it say please select .xlx,.xlsx,..... not .CSV comming can i directly excel CSV file loaded into db it is possible please send me a link

Nitin Sontakke · Answer

It appears that you are trying to learn SSIS. If yes, why don't you complete this absolutely FREE course from edX? https://courses.edx.org/courses/course-v1:Microsoft+DAT217x+3T2017/course/

Nitin Sontakke · Answer

CSV stands for comma separated values. It is NOT an Excel file. MS-Excel has just given the facility to view it as rows and columns, that's it. This is because rows and columns is the default view of MS-Excel. CSV files are plain text files, which can be (and should be) opened using NotePad or NotePad++. Check flat file / text file provider in SSIS and appropriately answer the questions in the wizard.

Uehara Ayaka · Answer

This link might be helpful - How to Convert CSV to Datatable in C# https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/CSV-to-Datatable-Convert-CSV-to-Datatable-with-C-VB.NET.html

Amudhan Kuppan · Answer

thanks

Shahriar Nikkhah · Answer

I assume that you are working on CSV try this link for CSV, you can download the codes https://sqldataside.blogspot.ca/2018/04/looping-through-flat-files-using-ssis.html

CSV file to database

Answers (5)