Thread: Writing SQL query to import specific data to a pivot tableatabase

Hi,

Using either VBA code or the Excel functionality of Pivot Tables, how would I construct an SQL query to import data from a SQL server database into a pivot table, but filtering out certain items from one of the fields before it gets to the pivot table?

For example what's the syntax of the Select statement to extract records where say the field named "Actioned" = "N"

Usual TIA

SELECT * FROM tablename WHERE Actioned = 'N'

Have you tried constructing it via MSQuery?

Hi,

Thanks for the prompt response.

In Excel 2007 and the MSQuery option, where would I incorporate the Select statement?

Regards