Thread: Ado Filter ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] peregenem@jetemail.net is offline
external usenet poster
 
Posts: 7
Default 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$]