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":
- 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":
- Click Next and Next
- Click on Finish
