If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Screen Scrape"
Does anyone know how to do a "screen scrape" to get data off a website and
enter it into an Access table? Thanks for all help? Steve PC Datasheet |
#2
|
|||
|
|||
Take a look at my November, 2003 Access Answers column in Pinnacle
Publication's Smart Access for one approach. You can download the article and accompanying database at http://members.rogers.com/douglas.j....artAccess.html -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PC Datasheet" wrote in message nk.net... Does anyone know how to do a "screen scrape" to get data off a website and enter it into an Access table? Thanks for all help? Steve PC Datasheet |
#3
|
|||
|
|||
"PC Datasheet" wrote in message nk.net... Does anyone know how to do a "screen scrape" to get data off a website and enter it into an Access table? What are you looking for exactly? Are you trying to download data from database? If so, I use the Internet Transfer Control from VB to connect to and download the page. Then I parse out the data for which I'm looking. The trick is in how you formulate the URL to query the database and get what you want. If you're just looking to download an entire page, you can just save the data and store it in a memo field. Again, using the Internet Transfer Control. I am in business to provide customers with a resource for help with Microsoft Access, Excel and Word applications. I can help you with this. If you would like my help, contact me at my email address (take out -nospam4me). Mike |
#4
|
|||
|
|||
"Mike Turco" wrote
I am in business to provide customers with a resource for help with Microsoft Access, Excel and Word applications. I can help you with this. If you would like my help, contact me at my email address (take out -nospam4me). LOL Steve - now don't you regret asking for advice? |
#5
|
|||
|
|||
No, not at all!
If this is important enough for me to get this to work and I am not able to get it myself, I now have a resource to go to for help. It's solely my decision on whether I want to pay for the help but I have someone to go to if I decide I want to pay. Steve "Darryl Kerkeslager" wrote in message ... "Mike Turco" wrote I am in business to provide customers with a resource for help with Microsoft Access, Excel and Word applications. I can help you with this. If you would like my help, contact me at my email address (take out -nospam4me). LOL Steve - now don't you regret asking for advice? |
#6
|
|||
|
|||
"PC Datasheet" wrote
If this is important enough for me to get this to work and I am not able to get it myself, I now have a resource to go to for help. It's solely my decision on whether I want to pay for the help but I have someone to go to if I decide I want to pay. Ah, Steve, surely you could not have missed Mike's point -- his is almost a word-for-word copy of what you use to flog your for-pay service in the newsgroup. Have a nice day. |
#7
|
|||
|
|||
what a hoot!
-- Duane Hookom MS Access MVP "Larry Linson" wrote in message ... "PC Datasheet" wrote If this is important enough for me to get this to work and I am not able to get it myself, I now have a resource to go to for help. It's solely my decision on whether I want to pay for the help but I have someone to go to if I decide I want to pay. Ah, Steve, surely you could not have missed Mike's point -- his is almost a word-for-word copy of what you use to flog your for-pay service in the newsgroup. Have a nice day. |
#8
|
|||
|
|||
Ah, Steve, surely you could not have missed Mike's point -- his is almost a word-for-word copy of what you use to flog your for-pay service in the newsgroup. Have a nice day. There are two kinds of people on this group: available consultants and potential customers. I would love to come to this group and say, "HEY EVERYONE I CAN FIX IT HIRE ME!!!!". I just think that's inappropriate for this group. I've wanted, for some time, to add a sig line to my posts and use these groups more frequently in hopes of getting the word out, but I don't. I'm sure others feel the same way. Usenet, especially these tech groups, is not a place where its acceptable to hock your wares. Where to advertise? How to get the word out on what you do? That's off-topic to this group. To answer that question I would suggest people try the newsgroup misc.business.marketing.moderated, misc.business.consulting or alt.computer.consultants.moderated. (FWIW, I moderate two of those three groups.) IMHO. Mike |
#9
|
|||
|
|||
"PC Datasheet" wrote in message
Does anyone know how to do a "screen scrape" to get data off a website and enter it into an Access table? Mike Turco wrote: [snip helpful part] I am in business to provide customers with a resource for help with Microsoft Access, Excel and Word applications. I can help you with this. If you would like my help, contact me at my email address (take out -nospam4me). Marvelous! What goes around, comes around, eh Steve ;-) -- Marsh MVP [MS Access] |
#10
|
|||
|
|||
I'd say it was OK to add a corporate website to your sig (e.g. Dirk) If I'm
interested then I can look further, if not, then I don't. ....and I'm neither of your two kinds by the way.... but I know what you mean. "Mike Turco" wrote in message news:4tBId.13327$nt.10704@fed1read06... Ah, Steve, surely you could not have missed Mike's point -- his is almost a word-for-word copy of what you use to flog your for-pay service in the newsgroup. Have a nice day. There are two kinds of people on this group: available consultants and potential customers. I would love to come to this group and say, "HEY EVERYONE I CAN FIX IT HIRE ME!!!!". I just think that's inappropriate for this group. I've wanted, for some time, to add a sig line to my posts and use these groups more frequently in hopes of getting the word out, but I don't. I'm sure others feel the same way. Usenet, especially these tech groups, is not a place where its acceptable to hock your wares. Where to advertise? How to get the word out on what you do? That's off-topic to this group. To answer that question I would suggest people try the newsgroup misc.business.marketing.moderated, misc.business.consulting or alt.computer.consultants.moderated. (FWIW, I moderate two of those three groups.) IMHO. Mike |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Jump from Blank screen to slide N during presentation | Yohs | Powerpoint | 3 | December 30th, 2004 07:23 PM |
Excel should allow me to screen scrape the data only | Les Ferrington | General Discussion | 4 | October 18th, 2004 02:25 AM |
Blue Screen; Can't write to drive C: | Felipe Quezada | General Discussions | 0 | October 1st, 2004 04:32 PM |
Some Screen Tips Are Missing | [email protected] | Setup, Installing & Configuration | 3 | June 28th, 2004 09:27 PM |
Print Screen Issues with Dropdowns | JulieD | Worksheet Functions | 0 | June 1st, 2004 04:47 PM |