Is there any way to define (or remove) the text qualifier when importing data using a web query?

I have a file that is tab delimited but has double-quotes within some of the fields. When I import the file the default text qualifier is double-quotes so many fields get put in a single cell. However, when I re-import the file with the text qualifier as {none} the file imports perfectly.

The problem I have is importing the file using a web query because I cannot find a way to set the text qualifier to {none}. Anyone run into this before and figured out how to fix it or work around it? Please note, changing the source data is not an option.

Code snippet
With ActiveSheet.QueryTables.Add(UrlStr, Range("A1"))
End With