Log Parser 2.2: select some columns from CSV (with no column names) into SQL

Hi all,

I have a problem with Log Parser 2.2 and CSV files I hope you can help me with. I have some CSV log files which unfortunately have no column names, but I only want to select certain columns from the CSV to insert into SQL. Is there a way around this? If there were column names, I'd be able to do: select col1, col3, col9 etc, but as they don't exist, is there another way (like select 1,2,3)?

Thanks

Jon