I dedicate this article to my mother Prajavathi.
This article shows how to import and export from a File to a
table/view and vice versa using SQL Server 2000 Bulk Copy Program (BCP)
utility. BCP is the fastest and easiest way to import and export from a file. This
article will be very useful to a developer by simply plugging in this stored
procedure wherever it is needed or to execute it to get the result. I have
used BCP for import/ export from a text file and a DOS shell command to execute
the BCP command.