Best Way to Import Data From a Web Browser

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

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---
 
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.
 
Back
Top