Is it possible to export Excel sheet data to..

A

avinoam.aharoni

Subject: Is it possible to export Excel sheet data to..

Is it possible to dump Excel sheet data to Access DB in real time (or once a minute or so, or per calculation event or other event)? if so - how?

Thanks.
 
E

Earl Kiosterud

Avinoam,

You may be able to use a linked table in Access. File - Get external data -
Link tables. The data is kept in the Excel sheet, but can be used in Access
as with any other table.
 
Top