Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: inserting data from a file

Re: inserting data from a file

From: <lbunet_at_yahoo.com>
Date: 16 May 2005 07:13:13 -0700
Message-ID: <1116252793.863032.287410@f14g2000cwb.googlegroups.com>

Preston Kemp wrote:
> 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'.
>

You're correct. My error. Sorry Vince.

LB

> --
> Preston.
Received on Mon May 16 2005 - 09:13:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US