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
