Using a WILDCARD (%) in the SELECT clause
 

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!!!

Using a WILDCARD (%) in the SELECT clause
 

Here's the code generated by Access for something similar:

SELECT Table1.test
FROM Table1
WHERE (((Table1.test) Like "*05"));

hth,

Doug

"cg" wrote in message
...
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!!!

Using a WILDCARD (%) in the SELECT clause
 

Most likely you would need to examine the Field names first, and use that
information to construct your select SQL.

Or just pull all columns and loop through the fields, using only those with
the required headings.

Tim

"cg" wrote in message
...
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!!!