Import data from web

K

kr

I work in a call center. we have all of our calls recorded and we can access
the total calls for the day via a website.
everyday, i access the site. pull the calls and export into excel (as that
is the only option for output). then i import the excel in access to
manipulate data.
What i would like to do is just go straight through access to obtain the
info from the website. can this be done through the external data? if so how?
the site of course has a password, and drop down menu, and date parameters.
can i make access automate this process?
 
K

kr

Its stored in a database. the program is switchvox. I pull the data by data.
what i have to go to the site everday (or so) sign in, go to the menu, select
date, and output to excel. just wanting to simplify as i am giving the
process info to others. if i could access and query somehow. dont' know if
i'm even making sense, but let me know if possible.
 

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

Best Way to Import Data From a Web Browser 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import Web Data 1
Import XML from web through code 0
Automating Excel Data Import 8
Import Data from Excel 2
how can I export an Access 2007 table to .dbf 1
No *.xls selection to import 3

Top