By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,430 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

A.I. and automatic searching and retrival from online search engines using Access ?

P: n/a
I have certain words, or groups of words (4 or less) input in my fields in
Access 2002 xp pro atmosphere.

The data is essentially in the tables., so what I want to do is get access
with the click of a button to take each and every string from a specific
field and possibly each and every single record ---> and place them
into the search field in one of the search engine websites such as the
google, altavista, or ask jeeves and run a search. Then take the
number of hits counter and import it back into access into a field for
display.

Is this possible ? why you ask.... well i want to know how popular
specific strings or words are on the internet, and part of this is to run
a search online and record the number of hits per search word. This
will help determine what actions to take. Otherwise I have to input
each word or phrase into the search engines and record the resulting
numbers, this would take days of work, whereas if I automate the
process with a high speed connection we can have several computers
working in parallel always updating the data while we sleep.

Artificial intelligence at work. Your suggestions and comments would
highly be respected.
Nov 12 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
Did you ever determine if this is possible? If so how do you do it?

Steve
"Jack-of-all-traits" <no*****@noemailaccount.info> wrote in message
news:lp********************@look.ca...
I have certain words, or groups of words (4 or less) input in my fields in
Access 2002 xp pro atmosphere.

The data is essentially in the tables., so what I want to do is get access
with the click of a button to take each and every string from a specific
field and possibly each and every single record ---> and place them
into the search field in one of the search engine websites such as the
google, altavista, or ask jeeves and run a search. Then take the
number of hits counter and import it back into access into a field for
display.

Is this possible ? why you ask.... well i want to know how popular
specific strings or words are on the internet, and part of this is to run
a search online and record the number of hits per search word. This
will help determine what actions to take. Otherwise I have to input
each word or phrase into the search engines and record the resulting
numbers, this would take days of work, whereas if I automate the
process with a high speed connection we can have several computers
working in parallel always updating the data while we sleep.

Artificial intelligence at work. Your suggestions and comments would
highly be respected.

Nov 12 '05 #2

P: n/a
rkc

"Jack-of-all-traits" <no*****@noemailaccount.info> wrote in message
news:lp********************@look.ca...
Is this possible ? why you ask.... well i want to know how popular
specific strings or words are on the internet, and part of this is to run
a search online and record the number of hits per search word. This
will help determine what actions to take. Otherwise I have to input
each word or phrase into the search engines and record the resulting
numbers, this would take days of work, whereas if I automate the
process with a high speed connection we can have several computers
working in parallel always updating the data while we sleep.

Artificial intelligence at work. Your suggestions and comments would
highly be respected.


The Google terms of service specifically states that automated queries
of any kind are not allowed.


Nov 12 '05 #3

P: n/a
Howdy RKC,

Then we can always use other search engines, or pay them for use.
"rkc" <rk*@yabba.dabba.do.rochester.rr.bomb> wrote in message
news:l_*******************@twister.nyroc.rr.com...

"Jack-of-all-traits" <no*****@noemailaccount.info> wrote in message
news:lp********************@look.ca...
Is this possible ? why you ask.... well i want to know how popular
specific strings or words are on the internet, and part of this is to run a search online and record the number of hits per search word. This
will help determine what actions to take. Otherwise I have to input
each word or phrase into the search engines and record the resulting
numbers, this would take days of work, whereas if I automate the
process with a high speed connection we can have several computers
working in parallel always updating the data while we sleep.

Artificial intelligence at work. Your suggestions and comments would
highly be respected.


The Google terms of service specifically states that automated queries
of any kind are not allowed.


Nov 12 '05 #4

P: n/a
RKC,

Actually upon further examination, the automated query applies to the
webhome
page of google, one cannot simply take the data off the web home page.

However there are ways via the API's development with google, and the use
of SOAP queries. You are limited to 1000 free per day per IP address
according
to the website.

Its a free start, from there maybe contacting google would be a good idea.

What do you think?
"rkc" <rk*@yabba.dabba.do.rochester.rr.bomb> wrote in message
news:l_*******************@twister.nyroc.rr.com...

"Jack-of-all-traits" <no*****@noemailaccount.info> wrote in message
news:lp********************@look.ca...
Is this possible ? why you ask.... well i want to know how popular
specific strings or words are on the internet, and part of this is to run a search online and record the number of hits per search word. This
will help determine what actions to take. Otherwise I have to input
each word or phrase into the search engines and record the resulting
numbers, this would take days of work, whereas if I automate the
process with a high speed connection we can have several computers
working in parallel always updating the data while we sleep.

Artificial intelligence at work. Your suggestions and comments would
highly be respected.


The Google terms of service specifically states that automated queries
of any kind are not allowed.


Nov 12 '05 #5

P: n/a
rkc

"Jack-of-all-traits" <no*****@noemailaccount.info> wrote in message
news:8M********************@look.ca...
RKC,

Actually upon further examination, the automated query applies to the
webhome
page of google, one cannot simply take the data off the web home page.

However there are ways via the API's development with google, and the use
of SOAP queries. You are limited to 1000 free per day per IP address
according
to the website.

Its a free start, from there maybe contacting google would be a good idea.

What do you think?


You can probably get/pay for permission to do most anything you want to do.

I've played around with the Google api's using java and one thing I noticed
is
that the getEstimatedTotalResultsCount is usually way off from the result
count posted if you do the same search from their home page.


Nov 12 '05 #6

P: n/a
Rkc,

So you obtained the key from google, and used the appropriate libraries and
code to execute a search and you only obtained deviant results ?

Thats no good, is that because the command used was "getEstimated" ?
You can probably get/pay for permission to do most anything you want to do.
I've played around with the Google api's using java and one thing I noticed is
that the getEstimatedTotalResultsCount is usually way off from the result
count posted if you do the same search from their home page.


Nov 12 '05 #7

P: n/a
rkc

"Jack-of-all-traits" <no*****@noemailaccount.info> wrote in message
news:hP********************@look.ca...
Rkc,

So you obtained the key from google, and used the appropriate libraries and code to execute a search and you only obtained deviant results ?

Thats no good, is that because the command used was "getEstimated" ?


Yes. I took about 3 minutes to obtain a key.
The getEstimated call and another that indicates whether that is the true
count
is all there is as far as I can see. Also, if you actually want to return
results from
a search the limit on the number returned is currently 10.
Nov 12 '05 #8

P: n/a
Are you saying that it took 3 minutes per query since it took 3 mintues for
key approval?
That would be far too slow and not useful.

Do you know of any other data mining companies other than google that have
permission
for greater than 1000 queries per day ?

See my more recent post in this newsgroup for more comments.
"rkc" <rk*@yabba.dabba.do.rochester.rr.bomb> wrote in message
news:jZ*******************@twister.nyroc.rr.com...

"Jack-of-all-traits" <no*****@noemailaccount.info> wrote in message
news:hP********************@look.ca...
Rkc,

So you obtained the key from google, and used the appropriate libraries

and
code to execute a search and you only obtained deviant results ?

Thats no good, is that because the command used was "getEstimated" ?


Yes. I took about 3 minutes to obtain a key.
The getEstimated call and another that indicates whether that is the true
count
is all there is as far as I can see. Also, if you actually want to return
results from
a search the limit on the number returned is currently 10.

Nov 12 '05 #9

P: n/a
rkc

"Jack-of-all-traits" <no*****@noemailaccount.info> wrote in message
news:Ic********************@look.ca...
Are you saying that it took 3 minutes per query since it took 3 mintues for key approval?
That would be far too slow and not useful.
No. I mean it took about 3 minutes to apply for and receive a key for
use with the api. Just playing around, re-directing the results to a text
file, the response time seemed quite fast.
Do you know of any other data mining companies other than google that have
permission
for greater than 1000 queries per day ?


Haven't ever looked into any others.

Nov 12 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.