Re: inserting data from a file

lbunet_at_yahoo.com wrote:

>
> 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).

I think he did post to the appropriate group - I read it as 'is there an equivalent to SQL Server's bulk insert command in Oracle'.

-- 
Preston.