Wildcard parameter in excel

  • Thread starter Thread starter BJC
  • Start date Start date
B

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.
 
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.
 
Back
Top