CSV import into DB

[Mark Drew]

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]

---