Re: inserting data from a file

From: <lbunet_at_yahoo.com>
Date: 10 May 2005 09:03:59 -0700
Message-ID: <1115741039.842355.322870@o13g2000cwo.googlegroups.com>

Vince wrote:
> Hello there!
>
> I would like to mass load data from file to table..
> is there any way such as 'bulk insert' in sqlServer ?
>
> thanks a lot :)
> ++
> Vince

exec master..xp_cmdshell 'bcp {database}..{table} in c:\{File_w_Data}-c -S{ServerName} -U{Username} -P{User's password}'

You can also user BULK INSERT (See BOL for syntax).

In the future, please post to the appropriate group (comp.databases.ms-sqlserver).

LB
"Most conflicts result from judgments made about adequacy of consideration." Received on Tue May 10 2005 - 11:03:59 CDT