Hopw can I Reverse-DNS lookup an IP Address?

[Aaron C]

Hi all,
I just got the (frustrating) task of taking the unresolved IP
Addresses of visitors to our web site, and parsing them (resolving
them) to find out how often our competitors are looking at it.
I am fully aware of the myriad ways that they can get around being
detected as our competitors.
Is there any way I can, in Excel, take an IP Address formatted as
xxx.xx.x.xx (variable length segments) and output a resolved hostname
for it?
Also, if I can only do it by visiting someone's web page, can someone
point me at one that does allows mass lookups all at once?

Thanks in advance,
Aaron C

 

[ShaneDevenshire]

Hi Aaron,

I am not an expert on IP addresses or even where the host name is in it.
Suppose you have a long column of these, you might try the Data, Text to
Columns command. You can use Delimited and then specify any delimiters you
want. You might need to repeat the process a number of times to get what you
want.

But if it works, it could be automated with VBA.

 

[Aaron C]

Unfortunately, what I need isn't contained within the IP Address. It's
contained on the computer the IP Address points to, or within a DNS
server, maintained by an outside company. So I need to do a lookup
against a remarkably huge database (that I do not have direct access
to), and/or query an individual computer... for each record.

 

[ShaneDevenshire]

Hi Aaron,

This doesn't sound like an Excel issue. Also, if you don't have access to
the database...

--
Cheers,
Shane Devenshire

Unfortunately, what I need isn't contained within the IP Address. It's
contained on the computer the IP Address points to, or within a DNS
server, maintained by an outside company. So I need to do a lookup
against a remarkably huge database (that I do not have direct access
to), and/or query an individual computer... for each record.