Fellow peeps

I have some CSV files exported from Requisite Pro.
When I just open them from Windows, they come in fine.

When I try to import them through VBA, the formatting is different and
my columns are screwed up.

Any ideas on exactly what parameters Excel uses during the opening of
a CSV so that I can set them programmatically?

Right now, I am using the Sheet.QueryTable method. I have played with
a bunch of the parameters with no luck. Is there another way to
import that emulates the way Excel does it from Windows?

Thanks much
Bob