Thread: Excel to Access
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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
.