How to enter more number of rows in a table having more number of columns at a time

Hi

I want to enter rows into a table having more number of columns
For example : I have one employee table having columns (name ,address,salary etc )
then, how can i enter 100 employees data at a time ?

Suppose i am having my data in .txt file (or ) in .xls

( SQL Server 2005)

Hi,

Where is the data coming from ? If you have all these information in a flat file, then Bulk insert will do it faster.

~mohan

sql