Is it possible to export Excel sheet data to..

  • Thread starter Thread starter avinoam.aharoni
  • Start date Start date
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel front sheet 1
Periodically exporting worksheet to HTML 2
Word to Excel: Export comments with text and line number 0
Copy Data from One sheet to Different Sheets 1
dump a multiple sheet excel file to a single text file 3
Connection/Refresh Control unavailable for imported XML data 0
Excel2007 | I want to create a pivotTable from a different data, and different sheets 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Back
Top