Monday, March 26, 2012

Read Text file from SqlServer

Hi Frinds,

I have the text file in my server.

Is it possible to read the text file and insert into table via sql server stored procedure.

yes. You can use BCP or BULK INSERT to do the job. Refer to Books Online for more details. http://search.live.com/macros/sql_server_user_education/booksonline

No comments:

Post a Comment