Web Hosting Info

Search:

featured partner

The IP to Country Database
  Forum Topics : Support / Imported the Database to Access, BUT!!
Submitted by hmaf on Wed, 04/07/2004 - 22:49.
Hi,

I imported the database to Access successfully, but I get the IP_From and IP_To in Long number as:
IP_Fom: 3585700224
IP_To: 3585700231

How to convert these numbers into a dotted IP using Excel or Access?

Thanks a lot
» login or register to post comments | previous forum topic | next forum topic | 1172 reads
Comment viewing options:
Select your preferred way to display the comments and click 'Save settings' to submit your changes.
Hope could help you
Posted by meteor73 on Tue, 08/10/2004 - 06:28.
When you import the csv file into the access as a new table, the IP-To field and IP-FROM field should use Number/Double data type instead of Integer. Because the integer data type in Access could only store numeric value not larger than 2,147,483,647 (2^31) but for the Double data type, the maximum number can be 10^28. Don't use string to store the value, because you have to use <= and >= in your query to get the Country.
» login or register to post comments
IP address to country
Posted by khaleeldeli on Wed, 08/11/2004 - 13:21.
Dear Sisters and Brothers...

How are you?

I have an excel file with one colum data and around 20000 rows. This data showing the IP address of my site visitor. That is like, 166.121.36.7, 212.140.152.254, 62.215.3.46 etc. I want to put in second column the country of respective IP address. If I am getting another list like IP address in colum and country in second column, I can take country from that file by using vlookup function. Can anybody help me to make a chart like this?. If you can, please mail to me: k@haidsf.com. And also can you explain, why this IP address seperated with some dots? what it resemples?

With best regards,
Khaleel Deli
» login or register to post comments