Excel can make queries through using the Filter options. They are not known as queries in Excel, but it is what they can do.
A web query.
SQL is Structured Query Language, and relates to databases. Excel is a spreadsheet application.
You do not really query in excel. If you need to do a lot of queries, use a database. However, you can replicate the effect by using the filter option. Highlight a column and turn on the filter, then select the item you would like to see.
You can search for something using Excel, but you would want to use Access to create a query. Please evaluate your requirements and ask the question again, using more specific terms of what you want to do.
no
range
You can copy data from Access and paste it directly into Excel. From a table or query, data can be selected and then copied and pasted into Excel. In that case, data changing in the original Access file will not change data in the Excel file. To do that there must be a link between the data. You can also import data from Access into Excel and from Excel into Access, again maintaining a link to the source if you want.
Create the report in a tab delimited format. It may have a suffix like txt or rpt. In Excel use the "Open" command. You will get a panel that allows you to refine where the column breaks are and define the format of the columns. Once this is done the data will be in Excel. Just save as a standard Excel file.
SQL means Structured Query Language. It is a programming language which is mainly used for maintaining databases. Excel is one of the application developed by Microsoft to do calculations, graphs using spreadsheets.
The traditional method of creating a web query uses the New Web Query menu command found on the Data menu under Import External Data.See related links for examples.
Worksheet
Pivot Tables are used in Excel. Access has a type of query known as a Crosstab Query, which works in a similar way. If your data is mainly numeric, then you use Excel. Non-numeric data is more suited to Access. So if you have the names, genders and departments of employees and wanted to find out how many males and females are in each department, then that would be good for Access. If you had a load of sales in different regions listed with their dates and wanted to find the total sales in each month for each region, then Excel would be better.