MS Query Problems

carlmack

New Member
Joined
Feb 11, 2005
Messages
39
I am learning how to import data in to Excel using a query and I have a couple of questions I would like some help with.

First, I have a query that brings about 6000 lines into Excel. I get the message “Selection is too large” during the query. All the data comes into the spreadsheet ok but the formulas to the right only extend down 1500 lines. Is there anyway round this ?

My second question is there a way to automate changing the selection criteria of the query. For example if the user of the spreadsheet enters a brand in a cell can this be automatically passed to the query as a selection criteria ?
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,994
The answer to your second question is yes. Right click on the data returned by your query, go to "Parameters" and set up a cell as an input.

Then, set up your query criteria to reference [parameter_name] such as "between [start_date] and [end_date]
 

carlmack

New Member
Joined
Feb 11, 2005
Messages
39
Thanks for the fast reply.

When I right click "parameters" is greyed out.

Any Ideas ?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,158
Messages
5,600,054
Members
414,357
Latest member
Gemma_R

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top