Thanks for all you help guys. I know its not the prettiest way of doing things but i got things to work. I am using 'Event[' as my rowterminator and...

Thanks for the replies. Is there no way to use BCP and Bulk Insert to perform this task?

I have created the .fmt file:

9.0

1

1 SQLCHAR 0 0 ...