Microsoft Access Into Excel

You can get Microsoft Access data into an Excel spreadsheet easily using QueryCell.

1. Select your Access database from the Data Sources drop down box.

(If you haven’t defined an ODBC connection to your database you can do so by clicking on the ODBC+ icon)

2. Check the Access DB Check Box.

3. Write the SQL Select statement that will retrieve the data into the SQL Editor and click the Run SQL button.

Comments are closed.