Hi John.
Thanks for your help.
I think I will end up writin g code to import the CSV file..I think its probably the cleanest and least complicated.
If you had any pointers on how to do this I'd appreciate it.

Regards,
Gerard



>>Hi Naomi , Kevin Thanks for ypur reply.
>>
>>I did not mention in original thread that my app is running in a device..comapct framework... it would appear Bulk updates not supported here ??
>>Do yopu know if this is the case, and io so, any alternatives ?
>>
>>Regards,
>>Gerard
>
>Gerard,
>
>On a compact device, SSIS and bulk insert are not available. What you could do, is use one of those into a desktop sql table and then replicate it to the compact device.
>
>Or, you gotta roll your own csv import. I can show you some code if you want to do that.
>
>Let me know..
>
>
>John