View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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