this will not be a one off but a way of populating a table remotely
using CSV files via an upload.
Seems to me that the SQL language is very limited in the INSERT INTO department.
MD
On Fri, 15 Oct 2004 12:01:15 +0100, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Mark
>
> 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]
