External Data from Web

[dutchpancake]

I have built a code which loops through a list of URLs, scrapes dat
from a specific table on that page, and then repeats the process wit
the next URL until finished.

This was working up until today. Now, suddenly I am seeing a pop-u
each time I try to load the next URL:

"File could not be accessed. Try one of the following:
- Make sure the specified folder exists
- Make sure the folder that contains the file is not read-only
- Make sure the file name does not contain any of the followin
characters: < > ? [ ] : | *
- Make sure the file/path name does not contain more than 218..."

here is a sample URL
http://espn.go.com/nba/playbyplay?gameId=311231025&period=0

I realize it has a "?", but it was working earlier today. I loope
through 50 URLs, before the code errored, and now I can't get i
working. I even went back and tried to manually create the Externa
Data Connection, but even that is not working.

Any thoughts

 

[Auric__]

I have built a code which loops through a list of URLs, scrapes data
from a specific table on that page, and then repeats the process with
the next URL until finished.

This was working up until today. Now, suddenly I am seeing a pop-up
each time I try to load the next URL:

"File could not be accessed. Try one of the following:
- Make sure the specified folder exists
- Make sure the folder that contains the file is not read-only
- Make sure the file name does not contain any of the following
characters: < > ? [ ] : | *
- Make sure the file/path name does not contain more than 218..."

here is a sample URL
http://espn.go.com/nba/playbyplay?gameId=311231025&period=0

I realize it has a "?", but it was working earlier today. I looped
through 50 URLs, before the code errored, and now I can't get it
working. I even went back and tried to manually create the External
Data Connection, but even that is not working.

Any thoughts?

Post your code.