I want to upload a Text file which is comma delimited into SQL Server
Database through.NET application. Can someone let me know the best way to do
it?
Can someone helpme with the stored procedure for the same as well?

Thank you in advance

http://www.sommarskog.se/arrays-in-sql.html
has some ideas of your interest.

--
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com


[quoted text, click to view]

you can use vb.net streamreader or text reader and
read the text file and then save the data to the dataset
that is bounded to the datbase and then call
the dataset update method

however

it is much easier to use DTS
or the Data transformation services of SQl server

--
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787


[quoted text, click to view]