Bulk inserts from inside SQL... <green with jealousy> Sybase doesn't have that
extension... </green>
At 03:06 PM 12/4/00 -0600, Billy Cravens 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.
>
>--
>Billy Cravens
>[EMAIL PROTECTED]
>
>
><message has been snipped>
>
>Peter Theobald wrote:
>
>> 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).
>
>
>> 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.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
