Can Microsoft Access Store and Process GIS Data?
Question details
The user wants to know if Microsoft Access is capable of storing and processing Geographic Information System (GIS) data like spatial data types and executing spatial queries.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Storing spatial data and executing geographic queries within a database application.
- Observed behavior
- Microsoft Access can store basic longitude and latitude numbers but lacks native support for complex spatial data types and advanced spatial processing capabilities.
Determine the complexity of your GIS data. If you only need to store simple latitude and longitude coordinates, standard number fields will suffice, but advanced spatial queries will require a supplementary database platform.
Integrate SQL Server Express for Advanced Spatial Queries
Connect Microsoft Access to a SQL Server database via ODBC to handle complex GIS data while keeping Access as your front-end user interface.
Because Microsoft Access does not natively support spatial queries, pairing it with a robust backend like SQL Server is the industry standard approach. SQL Server Express is a free version that fully supports spatial data types.
By linking the two, you can leverage Access for building forms and reports while SQL Server handles the heavy lifting of spatial databases in the background.
Download and install Microsoft SQL Server Express from the official Microsoft website. This free version natively supports spatial data types.
Create your database and tables within SQL Server, ensuring you utilize the appropriate spatial data types (such as Geometry or Geography) for your GIS attributes.
Open your Microsoft Access database. Go to the 'External Data' tab, select 'New Data Source', choose 'From Database', and then click 'From SQL Server'.
Follow the ODBC connection wizard prompts to link your SQL Server spatial tables to Access. You can now use Access forms to view and manage data while SQL Server processes the spatial queries.

Looking for a Free and Lightweight Office Suite? Try WPS Office
While managing complex spatial databases requires specialized tools like SQL Server, handling exported GIS data reports, spreadsheets, and documentation is seamless with WPS Office. It provides a highly compatible, free alternative to Microsoft Office.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the software: Run the installer and follow the straightforward on-screen instructions to set up WPS Office.
- 3. Open exported database files: Use WPS Spreadsheet or WPS Writer to open, edit, and format reports exported from your database.

Frequently Asked Questions
Can I store latitude and longitude directly in Microsoft Access?
Yes, basic geographic coordinates like latitude and longitude can be stored as standard numeric data types (such as Double) in Microsoft Access. However, you cannot perform geometric calculations on them natively.
Does Microsoft Access have native spatial query functions?
No, Access does not natively support spatial data types or advanced spatial queries. It cannot calculate distances or perform polygon intersections without custom VBA code or a backend spatial database.
Is SQL Server Express free to use for GIS data?
Yes, SQL Server Express is a free edition of SQL Server that fully supports advanced spatial data types and spatial querying, making it an excellent backend companion for an Access front-end.
How do I view GIS data stored in an Access database on a map?
Since Access lacks native map visualization tools, you typically need to connect your database to third-party GIS software (like QGIS or ArcGIS) via an ODBC connection to visualize the coordinates or spatial data.




