I'm a newbie around here - and I don't know if anyone is still paying attention to this thread - but I just found that was able to succeed with a maneuver like this when I used a schema.ini file with the entry Format=Delimited(|) in it, but I did NOT succeed when I used that same format statement as a part of the extended properties of the openrowset connection string.

Don't know why.....