Thank you, David, that's my next best option. My goal is to execute the select and
insert query from a cfm page
without any manual work.
David Baskin wrote:
> Nathan, if you have a comma delimited file with the data you want to import
> into a table you can do an import in Enterprise Mgr. right click on the
> table that you want the data in and go to all tasks > import data. point to
> the text file and follow the steps to import. HTH.
>
> d
>
> -----Original Message-----
> From: Nathan Chen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 16, 2001 8:57 AM
> To: CF-Talk
> Subject: OT: SQL Syntax
>
> Hi, Everyone:
>
> Does anyone know how the syntax of selecting data from a text delimited
> file and inserting into an exiting table? I kind of remember Oracle
> database provides this kind of tool but not sure how. I am now using MS
> SQL Server 7.0
>
> The simplied situation will something like this: a text file that
> consists of two columns, first_name, last_name.(tab delimited or space
> delimited). I need to select data in these columns and then insert them
> into a table that consists of two columns, first_name, last_name. I
> thought this would be a simple task but can't find any syntax in the SQL
> server books. Any help is appreciated.
>
> Nathan Chen
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
