Scraping text from web into Access

[abbeyainscal]

Ok, here's the problem that I have not been able to figure out to an easier way.

Say I'm collecting text from the internet and say that text is primarily names and addresses. From one website, it might be multiple names and addresses, for example (by the way, this is for sales leads for our company - nothing fishy!) -


HVACR:2-J Supply Co., Inc
4021 Bishop La.
40218 Louisville
Telephone: 502/969-8400
2-J Supply Co., Inc
872 Valley St.
45404 Dayton
Telephone: 937/223-0811
ACR SUPPLY CO INC
126 Everett Street
27215 Burlington
Telephone: 336-227-5000
ACR Supply Co.
101 Barnes Street
27510 Carrboro
Telephone: 919-929-2099
ACR Supply Co.
2719 Hillsborough Road
27705-4000 Durham
Telephone: 919-286-2228
ACR Supply Co.
2201 Binford Street
27407 Greensboro
Telephone: 336-854-5800

Ok, as we can see, the info repeats itself. So, other than what I've been doing, opening the file in Excel and transposing the data to columns, is there a way to get Access to recognize this into fields in a table I"ve already made? But, the part I don't get it how to get Access to do it over and over. The problem seems to be that in order to give something a field name, it has to be in columns.

I thought of this:

Field name: Data
Field name: Data

etc. but it doesn't work. My job would be so much easier if I could just figure this out and I fear that I"m not the expert I once was with Access (we're going back several years!). Thanks for any and all help - Linda

[ajetrumpet]

check this out: http://www.access-programmers.co.uk/...d.php?t=176968

[abbeyainscal]

I actually already worked with that idea but there is one sticking point, a lot of web pages won't allow you to read source code! But, just as an FYI, I found this: I can save the pages or cut/paste, whatever and open in excel. Then, I found a macro that will transpose data from columns to rows. So, once that is done, it's obviously then super simple to import into Access.

Your idea is fabulous IF I can read the source code, in a lot of instances it's blocked. Would you say that's maybe only true with IE8? Because I'm willing to try Firefox if you've found that to be more successfull. I appreciate your help - Linda

[ajetrumpet]

I
Your idea is fabulous IF I can read the source code, in a lot of instances it's blocked.

ummm...really? I've never seen one. PHP is blocked because it's server side. Show me a website where it's blocked. I'm interested...

[abbeyainscal]

Ok, try this link, when you attempt to view source code, IE craps out every time. - Linda

http://www.testo.us/online/abaxx-

What I would want to scrape out would be all the names and addresses that you see.

[ajetrumpet]

Ok, try this link, when you attempt to view source code, IE craps out every time. - Linda

http://www.testo.us/online/abaxx-

What I would want to scrape out would be all the names and addresses that you see.

LOL. the link is broken! on the flip side, i've never not been able to read source code with IE8 OR any of it's predecessors. as far as formatting and readability, there is no browser better than FF.