Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

import data from excel to an access text box!

Status
Not open for further replies.

ersatz

Programmer
Oct 29, 2002
114
US
In excel I have a cell that is linked to another app.This cell is updated real time (each second) with data. I want to see this data in a text box from a ms access form.
Any idea?
Thanks in advance,
ersatz
 
Hi,

You haven't mentioned where your Excel cell get's it's data from.
Also, it sounds dodgey to me that the cell is updated each second (why not only when it changes?).

It would obviously be simpler to update the Access field directly from the source - but what is the source?

Regards,

Darrylle
"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk
 
Hi Darrylle,
You have right, my cells is updated only when information changes.
The source is Reuters.
For me it will be the best solution, to update the Access field directly from the source but I don’t know to do that in ms access.
Any idea?
Thanks again,
ersatz
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top