Hi All,

I have a table in Access that I am using ADO to connect to in EXCEL. The
table has column headings by month-year (Ex. 01-05,02-05,03-05,04-05, etc.).

Is it possible to have the SELECT statement use a % wildcard to pull columns
that end in the year I specify? For instance, if I only wanted to see 2005
data I would have something like this: SELECT [%%-05] From Oracle so that it
would pull all the columns in the Oracle table that end in 05?

Thanks!!!