>from within a T-SQL script you can use Bulk Insert
>
>/* load the tables with sample data */
>BULK INSERT dbo.rm_source_codes
> FROM '\\Todd\JobLog\ph_sc.CSV'
>

That's the neatest solution I've found yet.

Many thanks,
Alan