ActiveSheet.QueryTables.Add
 

Hi,

The QueryTable is a great tool, but it gives you all or nothing. My approach
would be to import the entire file into a clean sheet, delete the info you
don't need, then transfer the data to its final destination.

Alternatively, you could switch to ADO and use a SQL string to define what
you want to retrieve.

HTH/

"Rick" wrote:

I am importing a CSV file and want to be selective in my data. I need to
bypass any record that does not have a char "V" in the specified column. The
above subject is also the standard QueryTables.Add statement. Any
suggestions?
--
Rick Rack