<div>
In Excel, click File, Open, File of Type (mdb, mde), Browse for the file, click, brose for the table or query.
</div>


In Excel, click File, Open, File of Type (mdb, mde), Browse for the file, click, brose for the table or query.

<div>
Can I send a result of a query to display as excel spreadsheet?
</div>


Can I send a result of a query to display as excel spreadsheet?

<div>
Can u show me a macro or automated way to implement it?
</div>


Can u show me a macro or automated way to implement it?

<div>
Some Notes:<br />
<br />
1. Access has much more powerful Reporting facilities than Excel does.<br />
What type of Report are you creating in Excel, that can't be recreated in Access directly?<br />
<br />
2. Just be aware that currently you cannot update the Access data via the Excel &quot;Front End&quot;
</div>


Some Notes:

1. Access has much more powerful Reporting facilities than Excel does.
What type of Report are you creating in Excel, that can't be recreated in Access directly?

2. Just be aware that currently you cannot update the Access data via the Excel "Front End"

<div>
<div class="content wysiwyg-content">
Id like to see how to link Excel and Access with Access as the backend.<br />
Id liek to create a report in e/xcel using access as the db.
</div>
</div>


Id like to see how to link Excel and Access with Access as the backend.
Id liek to create a report in e/xcel using access as the db.

Access backend and Excel Front End

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.