Wildcard parameter in excel
 

Hi,

I've returned the output of an Access Query into Excel using Data == Import
External Data etc by inputting a parameter into excel. Is it possible to
enter the parameter as a wildcard entry, instead of an exact parameter.

Eg entering 1234* to return this data range, rather than entering a specific
parameter such as 123456?

Thanks.

You could add a field to the query, in which you calculate the first
four characters. For example: LEFT(Amount,4)

In Excel, enter the four characters you want to use as the parameter.

BJC wrote:
Hi,

I've returned the output of an Access Query into Excel using Data == Import
External Data etc by inputting a parameter into excel. Is it possible to
enter the parameter as a wildcard entry, instead of an exact parameter.

Eg entering 1234* to return this data range, rather than entering a specific
parameter such as 123456?

Thanks.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html