LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Query doesn't add/delete data in rows on refresh boreal Excel Discussion (Misc queries) 2 October 12th 12 09:34 PM
External data query leaves datasource workbook open WhytheQ Excel Discussion (Misc queries) 0 May 4th 06 03:54 PM
Get External Data - not editable using Query Wizard MargaretBeckbury Excel Discussion (Misc queries) 7 January 17th 06 09:13 AM
Getting External Data with Saved Query Festus Bola Ademorijimi Excel Discussion (Misc queries) 4 July 21st 05 06:08 PM
Query to external data not refreshing R Ormerod Excel Discussion (Misc queries) 1 April 1st 05 08:39 PM


All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"