How do i import a table into access from a dynamic web url?

A

accessRPL

I have a database that is generating a table of items to be reviewed from an
active server page that returns an excel document.

I have managed to get the excel document into an iframe on a data access
page and idealy would like to import it into a table directly from there but
am unable to find and methods that i could call to get a handle on the excel
object within the frame, i could not even find a way to save the excel object
to disk. Is this possible?

I have achieved it manually by triggering the link to open in an external
explorer pane and selecting File -> Save which i am then importing using a
pre-defined linked table (local). This works fine but is inpractical for the
number of times that this would be needed to be carried out.

Any Suggestions would be great

Cheers

RPL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Excel 2010 table into Access 2010 - not listed as range 0
importing part of excel file into access 2
How to Change criteria on a saved query using VBA 0
some records will be imported from excel 0
Import from notepad Pipe delimited text document 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Get Excel Worksheet Names for Importing into Access Tables 4
Need VBA Macro to Loop through pages and print counter in footer of each page 9

Top