Parameters wthin Query of External Data

[Sean]

Is there a limit on the number of Parameters you can have, in order to
Import relevant information (from an Access to Excel sheet)?

I typically use only 10-12 Parameters, but now see the need on a
particular issue to increase that to 50, is that possible? and is there
n 'easy' way to achieve this. Unfortunately I can't do it within Access
(don't have the knowledge) so I have to filter the large Database by
eans of these Parameters

Thanks

 

[Guest]

I'm not aware of any limits.

Maybe export your data to XL then run XL's Advanced Filter tool on the data
to further refine it?

Dave