If you have Enterprise manager (and this is a one off task) you can run the
dts wizard which allows you to
Insert data into and from CSV, excels and numerous other file formats.
HTH
Kola
_____
From: Mark Drew [mailto:[EMAIL PROTECTED]
Sent: 15 October 2004 10:48
To: CF-Talk
Subject: CSV import into DB
I am doing an automated insert of a CSV file into a MS SQL database.
I am sure this has been done a million times, so I was wondering if
there is a better way that upload CSV, loop through each line and
insert each line one at a time into the db. Is there a better batch
import method?
--
Mark Drew
coldfusion and cfeclipse blogged:
http://cybersonic.blogspot.com/
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
