If you have a large data source, such as an Access database, a SQL Server database or even a large text file, you can also retrieve data from it using Excel. Using SQL statements in Excel enables ...

Launch Excel and open the spreadsheet you wish ... If your business uses Microsoft SQL... Return to Access and click "Create." Double-click the "Macro" button on the Ribbon to view the Macro ...

Use Excel’s MS Query Wizard to query Access databases Your email has been sent Don't have access to Access? You can use Excel to open the database you want, using the MS Query Wizard.