Support
Licenses
Products
Data design
Import
File formats
Coordinates
Languages
Payment types

Import

Microsoft Access

Follow the steps below to import the CSV data in Access:

Administrative Regions

  • Open or create a new Access database
  • Select Get "External Data"
  • Select "New Data Source" / "From File" / "Text File" (*.txt;*.csv;*.tab;*.asc)"
  • Browse directories and select your file (Geo-XX-4-XXX.csv) and click OK
  • Select Delimited and click "Advanced" button and select Unicode (UTF-8) as Code Page
  • Click Next, select Semicolon as delimiter and {none} as Text qualifier
  • Tick First row contains field names and click on Finish
  • Click Next, and select the following fields and change Data Type to "Short Text":
    • Region1Code
    • Region2Code
    • Region3Code
    • Region4Code
  • Click Next and Next
  • Click on Finish

Postal Codes

  • Open or create a new Access database
  • Select Get "External Data"
  • Select "New Data Source" / "From File" / "Text File" (*.txt;*.csv;*.tab;*.asc)"
  • Browse directories and select your file (Geo-XX-5-XXX.csv) and click OK
  • Select Delimited and click "Advanced" button and select Unicode (UTF-8) as Code Page
  • Click Next, select Semicolon as delimiter and {none} as Text qualifier
  • Tick First row contains field names and click on Finish
  • Click Next, and select the following fields and change Data Type to "Short Text":
    • PostalCode
  • Click Next and Next
  • Click on Finish

Streets

  • Open or create a new Access database
  • Select Get "External Data"
  • Select "New Data Source" / "From File" / "Text File" (*.txt;*.csv;*.tab;*.asc)"
  • Browse directories and select your file (Geo-XX-8-XXX.csv) and click OK
  • Select Delimited and click "Advanced" button and select Unicode (UTF-8) as Code Page
  • Click Next, select Semicolon as delimiter and {none} as Text qualifier
  • Tick First row contains field names and click on Finish
  • Click Next, and select the following fields and change Data Type to "Short Text":
    • PostalCode
  • Click Next and Next
  • Click on Finish