Parameters wthin Query of External Data
 

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

Parameters wthin Query of External Data
 

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
--
Brevity is the soul of wit.


"Sean" wrote:

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