Microsoft Query

[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

 

[WillR]

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

 

[augam]

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