Doing a bulk insert into SQL

[Paulson]

Hello everyone

I need to insert almost 150000 records into a table from a word file?How can I
do this in the most efficient way? Can you send me any related links or documents that will help me to do this?
Pls Help me out experts.
Thanks for help in advance.


bye Paulson.

[ck9663]

Hello everyone

I need to insert almost 150000 records into a table from a word file?How can I
do this in the most efficient way? Can you send me any related links or documents that will help me to do this?
Pls Help me out experts.
Thanks for help in advance.


bye Paulson.

Use the BULK INSERT or OPENROWSET


-- CK