Wildcard parameter in excel

[BJC]

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]

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.