Ado Filter ?
 

ThinkImInTrouble wrote:
I have a Connection built to an excel Worksheet using
Microsoft.Jet.OLEDB.4.0.

The Problem I am having is I need to Filter in the Second column of the
Table but the second column Header changes its Name or is left blank.

As I said earlier, don't use SELECT * in production code! You can use a
correlation name (alias)

SELECT F1 AS my_chosen_name FROM [Sheet1$]