Page 1 of 1

Duplicate records in CSV

PostPosted: Mon Jul 16, 2007 10:55 pm
by ilg1976
I found some duplicate values in CSV downloaded from ftp:wayne.

on country table: The IP 370474752 pointing to USA and CA.
On city table: The IP 100728576 pointing to
Vienna VA
Atlanta GA
Kansas City MO

Can anyone give explanation on what is going wrong, if i am correct?

I am using sql server. I created 3 tables from 3 CSV's downloaded.

Can anyone explain me how to use these database for locating ip addresses?