How do you get information from an Excel Web Query into Access?

[DoveArrow]

I work for a college, and we have a program, called Informer, that
automatically generates web queries from a database, called Datatel.
What I would like to do is somehow be able to automatically refresh
the web queries that Informer generates, and then import that data
into an Access database. Any ideas?

 

[CLR]

You could try opening Excel, and turning on the Macro Recorder, and then
recording a macro while going through the steps to retrieve the data, then
turning off the recorder. You would then have a macro that would run the
query for you......you may be able to edit it then to fit your special needs.

hth
Vaya con Dios,
Chuck, CABGx3

 

[DoveArrow]

You could try opening Excel, and turning on the Macro Recorder, and then
recording a macro while going through the steps to retrieve the data, then
turning off the recorder. You would then have a macro that would run the
query for you......you may be able to edit it then to fit your special needs.

hth
Vaya con Dios,
Chuck, CABGx3





- Show quoted text -

I'll look that up, but here's a question: I've seen some people talk
about how you can run a web query daily. How do you set something like
that up? Do you think that would solve my problem?

 

[CLR]

I do not run Web Queries personally, so can't give you first-hand info there,
but once you have a macro set up to perform the query once, you can run it
on demand, any time just by triggering the macro, or you can set it up to run
each time the Workbook that it is in, is opened.

Vaya con Dios,
Chuck, CABGx3