From Access you can use DoCmd.TransferSpreadsheet to either link ("live"
updates) or import("snapshot") the Excel data - see the Help file in Access
for details. As far as updating whenever Excel updates, there is no way for
Access to know when the Excel file has been updated without some sort of
two-way communication going on - meaning either a link or some code in the
Excel workbook that triggers an export to Access. But you should be able to
set up an import routine in Access and run it when you start up the Access
app, or when you press a button, or even linked to a timer if desired.

And I am sure that with some creative VBA coding in Access you could import
directly off the web, duplicating a web query, but that is not something I
have any direct experience with...

"Todd Hudson" wrote:

Is it possible to have an access database updated from an Excel
workbook/worksheet. I want the database to be updated everytime the Excel
file is updated. Or, is it possible to create an access database that will
include the web queries that are created in an excel file?

Thanks