How can I use a SQL query to retrieve data on a database sever? I have connected to a SQL server in Excel . I want to be able to import data from a table located on the server. However this table is too big to import into Excel, I'm talking millions of rows. I only want to import certain data into Excel, for example only import the data where the date is between a certain range. Where can I do this in Excel? If there are any alternatives to retrieving data from a large database please let me know.
In EXCEL, from the Data ribbon, Get External Data tab, select From Other Data Sources -> From SQL Server.

Follow the wizard to connect to your server and create a query.