Access Front-end, Excel Back-end

Based on your input, I decided to use Access as a way for multiple users to co-author a database. But now I would like to "link" the database to Excel, so I can use it as my front-end application (there is a specific reason for this that I can get into, if need be).

What is the most efficient way to stream-line data from Access to Excel? Is there a way to link?

Your help is much appreciated, as always.

It seems there is more to this,what is this a follow on from?

Trying to have multiple users co-author an Excel spreadsheet...I decided to use Access for the co-authoring a find a way to then update/populate Excel.

Nobody here helped, but I believe this is the answer for those who are interested. One of the gurus might be able to confirm, but it appears to work fine on my PC.

"This can be done, and you should start from Excel. Choose Data, Import External Data, New Database Query. From the Databases tab click the MS Access Database link. Enable the Use the Query Wizard to create/edit queries checkbox then click Ok.

Now select the Access database and click Ok to open it. Now choose the table to use from the list on the left and click the chevron to move this to the right pane. Click Next to continue. You can now create a query to return only a subset of the data if you want to – otherwise skip this step. To do this, click a field to use to filter it on and, in the dialog, specify the criteria which determines what data you want to see.

Click Next to continue and choose a Sort order for your data, if desired. Then click Next to continue. Select the option 'Return Data to Microsoft Office Excel' and click Finish. Now select the cell which will become the top left cell of the data range and click Ok. The data will now appear in the worksheet.

To determine how and when the data is refreshed, click the Data Range Properties button on the External Data toolbar. You can select for the data to be refreshed on opening the Excel file, and/or every nn minutes. You can also refresh the data anytime by clicking the Refresh button on the External Data toolbar."