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
