| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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$] |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
| Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
| filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Linear Mode
