...
| Code Block | ||
|---|---|---|
| ||
BULK INSERT [dualshield_database_name].[dbo].[ip2location_db3]
FROM 'FILE-PATH-TO\IP2LOCATION-LITE-DB5.CSV'
WITH
(
FORMATFILE = 'FILE-PATH-TO\DB5.FMT'
)
GO |
...
* replace "FILE-PATH-TO" with the actual file path where the downloaded file is saved, e.g. "c:\downloads"
* For dualshield version < 8.0, the name of the table in the database is called "ip2location_db3", although the import file is called "db5.csv"
...