The bulk-import facility is different for each database.
Sybase has "BCP", a command line utility that you would access through CFEXECUTE.
SQL-Server has "Enterprise Manager", which is interactive. I don't know how you would
automate using it (one of the reasons why I am a Unix fan not an NT fan, everything on
Unix is built to be automated and scripted).
I am sure Informix and Oracle have their own facilities as well.
Importing large amounts of data through many many many SQL inserts statements in a
CFML page is very inefficient and slow. Even worse at least for Sybase/Linux it
crashes occasionally due to a very careless error in the Merant Sybase ODBC driver.
At 01:11 PM 12/4/00 -0400, Michael Gagnon wrote:
>Hi!
>
>I am looking for a way to batch import data into a table
>using Cold Fusion (or other means) through
>the Internet. I have 2 columns, Fullname and email.
>
>Does anyone know of a way that I could do this?
>
>Thanks!
>
>________________________
>Michael Gagnon
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
