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$]
|