Live Data in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nate - 11 Jan 2008 02:25 GMT

I am having trouble getting live data in my Access Database. The data is
retrieved from Thompson One. In Excel, this is a simple formula such as
=ilx...As the market chages, the quote is updated in Excel. I would like to
have a text box in an Access form that is similar and updates as the market
changes (i.e. bid/ ask).

If this canno't be done in Access, is there a way to have a live link to an
Excel spreadsheet? As the data changes in Excel, the linked table in Access
changes as well. This has been a thorn in my side, any help would be greatly
appreciated.

Reply to this Message

Pat Hartman - 11 Jan 2008 14:55 GMT

You can do this in Access if you can find a web service to provide the data.
Look at the code behind the Excel sheet and see if you can copy it.

>I am having trouble getting live data in my Access Database. The data is
> retrieved from Thompson One. In Excel, this is a simple formula such as
[quoted text clipped - 11 lines]
> greatly
> appreciated.

Reply to this Message

Nate - 11 Jan 2008 18:26 GMT

The service used is Thompson One, which uses ILX data. The code is password
protected, but is labeled as ilx.xla. Various ilx options also show up under
references in access (as .dll files). Do I need to write a module to
reference the .ilx options? If so, do you have any sort of examples, or
examples of referencing a web service?

Thanks in advance

> You can do this in Access if you can find a web service to provide the data.
> Look at the code behind the Excel sheet and see if you can copy it.
[quoted text clipped - 14 lines]
> > greatly
> > appreciated.

Reply to this Message

Pat Hartman - 11 Jan 2008 21:41 GMT

We have exhausted my knowledge of this particular subject.

> The service used is Thompson One, which uses ILX data. The code is
> password
[quoted text clipped - 27 lines]
>> > greatly
>> > appreciated.

Reply to this Message