) ON Importing the CSV data into MSSQLīefore import, you will need to create an FMT file to control how the import will load the data into the table.Ĭopy and paste the code below into a text file called DB25.FMT then save it to the same folder that you have saved the CSV file. Run the below SQL command to create a new table in the database for storing the IP2Location data. We will assume you have already setup MSSQL and you have. We will not cover the installation of MSSQL and. The aim of this guide is to demonstrate how to import IP2Location data (DB25) in CSV form into Microsoft SQL Server 2008 R2 and then query the data in VB.NET.įirst of all, you will need to download the IP2Location DB25 CSV file.Įxtract out the IPV6-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE-TIMEZONE-ISP-DOMAIN-NETSPEED-AREACODE-WEATHER-MOBILE-ELEVATION-USAGETYPE-ADDRESSTYPE-CATEGORY.CSV file from the downloaded zipped file and save it to C:\ folder. Importing IP2Location data into MSSQL (IPv6)