Function to get Access Data

  • Thread starter Thread starter Dustin
  • Start date Start date
D

Dustin

Is there any function or other way to have data in a cell
updated automatically from data in Access?

I have a scale program entering records into a table in
Access, and I need access to pass the data it recieves
along to excel as soon as it recieves it.

I'm running out of time, and I really need help on this.

Any helps greatly appreciated,

Dustin
 
They are called queries, go to

Data> Get External Data> New Database Query

and follow the signs.
 
Hi Dustin

goto 'Data - Import External Data - Import Data". Select you data
source and your MS Access database.
You can now select your table/query.

Depending on your settings for this external data link the cell will be
updated periodically, at startup or manually

HTH
Frank
 
Back
Top