| Author: Vadivel Mohanakrishnan 03 Oct 2006 | Member Level: Diamond | Rating:  Points: 2 |
Make use of "Bulk Insert" command in SQL Server.
If at all you are looking for a working sample chk this out: http://www.sqlteam.com/item.asp?ItemID=3207
Best Regards
Vadivel
MVP SQL Server
http://vadivel.blogspot.com
|
| Author: Immanuel 03 Oct 2006 | Member Level: Bronze | Rating: Points: 2 |
Hi Nagandra,
Your issue can be solved by using bulk Insert,A feature of SQL Server. Have this sample code
BULK INSERT Northwind.dbo.[Order Details]
FROM 'f:\orders\lineitem.tbl'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = ':\n'
)
|