Excel to Access
Link to the xl file range.
fileget external datalink tables. follow the wizard.
this link will be just like an access table and can be use
anyway an access table can be used.
I do it all the time. keeps the size of the access db
down, save disk space by eliminating redundunt data.
Why have the same data in two places?
-----Original Message-----
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
.
|