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---
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---