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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists