my big chalenge - import acces data in excel

  • Thread starter Thread starter J-Philippe
  • Start date Start date
J

J-Philippe

Hello,

I want MSExcel to get data from a MSAccess table/form in
constant time intervals.In brief, I am monitoring
temperatures on a control PC in MSAccess and I would like
to log them from my computer in the lab (another machine
in another room).

I can do all the programming BUT I cannot get Excel to
talk to Access. I could only do it with arrays.

On top of that (Ideally), i would like to do that over a
network... i.e. MSexcel on a machine and MSaccess on
another. However, I can live if it is on the same machine.
ie. I can walk! :)

Tell me what you guys think about this!
J-Philippe
 
J-Philippe said:
I can do all the programming BUT I cannot get Excel to
talk to Access. I could only do it with arrays.
Click to expand...
Have you tried Data / Get External Data / New Database Query
to set up a query, which in recent versions of Excel you can set to run
at pre-determined intervals.?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Back
Top