Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
my big chalenge - import acces data in excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
my big chalenge - import acces data in excel
Try here - I've got it to work for me.
http://www.erlandsendata.no/english/...php?t=envbadac Rgds GB Gary Bartlett - Productivity Solutions Phone 0800 776-276 (NZ) / +64 9 476-2530 (International) Mobile +64 274 776-276 Fax +64 9 478-8747 http://prodsol.co.nz - dramatic improvement through pattern-level intervention "J-Philippe" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Excel Front end Acces Back end | Excel Discussion (Misc queries) | |||
Can I use Excel to make Inventory without using Acces? | New Users to Excel | |||
Working betwen excel and acces | Excel Discussion (Misc queries) |