How would the format file look like for the following

I have the follwing txt file with quoted comma delimted file

"col1","Col2","col3","col4","col4","col5","col6","col7"

"text for col1","123 NW St, Suite 23",,,"12345","AZ"

I would have no problem...

The new xml functions runs more effeciently than the old OPENXML, that is why you suggest this? If I have a file I need to load, I was use

SET...