Thanks. This is the only reference I could find that advised about he 'InProcess' option and that resolved my issue.

Ignore my last.

When I copied the BULK INSERT statement I missed the last semi-colon. The error message was misleading.

Yes Jeff. Works like a charm and thanks for posting...

I'm using SQL2012 and following your steps as carefully as possible.

I have copy and paste your example code and data.

When I run the BULK INSERT in Studio the result is...