Best Way to Import Data From a Web Browser

[ryguy7272]

At my firm we log into a Siebel DB, or maybe it is Oracle, I’m not exactly
sure. Anyway, all the data is accessed through a web browser (Explorer,
Firefox, etc.). Getting the data is somewhat of a manual process so I was
hoping to automate things to the greatest extent possible with Access. I can
easily record a ‘New Web Query’ macro with Excel, but during the import
process Excel grinds to a slow pace, and sometimes, doesn’t even the task.
When it does work, I still have to transfer the data from Excel to Access,
and I was just looking for a simple way to get everything in Access and keep
it in Access. Is there as easy way to do perform a query based on data that
loads into a web browser? I even saved the data as an HTML file, and tried
to import it into Access, but that didn’t seem to work well at all. Perhaps
I am doing something wrong. Can someone please suggest a solution?


Regards,
Ryan---

 

[SQL Brad]

If you always output or save the web-data in the exact same format in Excel,
you could write a macro in Access to automatically import that data into
Access. Or if you can save the data from the browser as text (comma
delimited, tab delimited, etc) that might work. I suspect your apps are
grinding to a slow pace perhaps because of the extraction tool you might be
using.....if your company is using oracle or Siebel, it might be due to
security on the network, etc.