Microsoft Query

  • Thread starter Thread starter augam
  • Start date Start date
A

augam

Is there any way that I can choose what data I want from a SQL databas
without having to use Microsoft Query.

eg I would like to have a set of data based on date selection, can thi
be added as a macro in the Excel spreadsheet.

In anticipatio
 
You can use MSQuery with cell values as parameters you know (i.e. have a
From date in A1 and a To Date in B1 & return all records between those
dates...)

Post back if you need help on configuring your query to work with
Parameters.

Alternatively, you would probably need to code it using VBA and pass
your variables to the SQL string from the worksheet at runtime.

Will
 
I can select using Microsoft Query, it is when I pass this on to other
users I want them just to select from the Excel spreadsheet the data
they require
 
Back
Top