see SQLLOAD in an Oracle reference book...
> -----Original Message-----
> From: Mike Amburn [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, December 12, 2000 6:55 AM
> To: CF-Talk
> Subject: RE: Bulk imports into database - what about ORACLE?
>
> does anyone have any suggestions for bulk imports into oracle?
> is there an equivalent SQL statement for oracle?
>
> we have been using data junction, but we're looking for an in house
> solution.
>
> -mike
>
> > -----Original Message-----
> > From: paul smith [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, December 04, 2000 8:18 PM
> > To: CF-Talk
> > Subject: Re: Bulk imports into database
> >
> >
> > I use the following for BULK INSERTs
> >
> > <cfquery name="InsertInitial" DATASOURCE="#DSN#" USERNAME="#user#"
> > PASSWORD="#pass#">
> > BULK INSERT Victor
> > FROM 'D:\FR\FileResource\101-200.csv'
> > WITH
> > (
> > FIELDTERMINATOR=',',
> > ROWTERMINATOR='
> > '
> > )
> > </cfquery>
> >
> > Very fast!
> >
> > best, paul
> >
> > At 03:06 PM 12/4/00 -0600, you wrote:
> > >Actually, Enterprise Manager is just a front-end to SQL Server, and
> > >you'd want to automate the "back end", not the "front end".
> > >
> > >For SQL Server, take a look at "BULK INSERT" (look in the Books
> > >Online). It allows you to take a text file containing your data, and
> > >bulk insert that data (duh) into a table you specify. The
> > syntax is a
> > >bit trickier than that, but fairly simple.
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
