Selective fields in csv to database

Question

hi In one website I want to save some fields of csv in database.I use sql server 2008.How it is possible to save particular fields in database.

Sam Hobbs · Answer

It depends on a few things. It depends on whether you can use SQL Server tools instead of writing a program. If you must write a program then there are a few relevant articles in this web site. I know there are because I wrote one of them and I know there are others.

Kunal Vaishya · Answer

Dear , refer this link Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} http://blog.sqlauthority.com/2009/11/25/sql-server-comma-separated-values-csv-from-table-column/

Selective fields in csv to database

Answers (2)