...
1 - Create a data-format file, name it with suffixthe file extension ".fmt", e.g. DB3.FMT. Copy the content below to the file:
Code Block | ||
---|---|---|
| ||
12.0 7 1 SQLCHAR 0 1 "\"" 0 first_double_quote Latin1_General_CI_AI 2 SQLCHAR 0 20 "\",\"" 5 ip_from "" 3 SQLCHAR 0 20 "\",\"" 6 ip_to "" 4 SQLCHAR 0 255 "\",\"" 3 country_code Latin1_General_CI_AI 5 SQLCHAR 0 255 "\",\"" 4 country_name Latin1_General_CI_AI 6 SQLCHAR 0 255 "\",\"" 7 region_name Latin1_General_CI_AI 7 SQLCHAR 0 255 "\"\r\n" 2 city_name Latin1_General_CI_AI |
*Ensure Make sure that there is a carriage return after the last format-file row.*
2 - Log into the MS-SQL studio
...