Follow these general best practices when creating Excel data to be used in ArcGIS Pro: You can work with Microsoft Excel files in ArcGIS Pro in the same way as other tabular data sources, but there are a few limitations. Available worksheets are shown in the Sales_Figures workbook on the Add Data dialog box.įormat a table in Microsoft Excel for use in ArcGIS Pro.Three worksheets are shown as they appear on the Sheet tab bar at the bottom of the Excel window. The following example contrasts how a multisheet document is exposed in Microsoft Excel and on the Add Data dialog box: However, you cannot edit the table or export records to an Excel format. Once the table is added to the map, you can open it in the Contents pane. Worksheets with names containing spaces will have the spaces replaced by underscores. When accessed from ArcGIS Pro, a worksheet is shown as a table with a dollar sign ($) at the end of its name. For example, if you have an Excel workbook named Sales_Figures.xlsx that contains three worksheets-Sales, Month, and Year to Date-each worksheet is a separate table in ArcGIS Pro. When you browse to an Excel file, you must choose the table you want to open. You add Excel files to a project in the same way as other data: click the Add Data button It is recommended that you restart your computer after the installation. To work around this problem, you will need to perform a silent installation of the downloaded file by doing the following:
ODBC EXCEL COLUMN TYPE INSTALL
A similar error message will display if you try to install the AccessDatabaseEngine_X64.exe file on a machine that already has a Microsoft 32-bit application. If you try to install the downloaded AccessDatabaseEngine.exe file on a machine that already has a Microsoft 64-bit application, you will get an error message saying that you cannot install a 32-bit version of the database engine because you currently have 64-bit Office products installed.
ODBC EXCEL COLUMN TYPE DRIVER
AccessDatabaseEngine_X64.exe-64-bit driver.If you are using ArcGIS Pro 2.5 or later,Ĭhoose the download that matches your currently installed Microsoft.If you are using ArcGIS Pro 2.4, choose the.
ODBC EXCEL COLUMN TYPE 32 BIT
To work with Excel files in ArcGIS Pro, you must download and install the Microsoft Access Database Engine 2016 Redistributable from the Microsoft Download Center.Ĭlicking Download on the page will present you with a choice of two downloads, 32 bit or 64 bit: If you attempt to access an Excel file in ArcGIS Pro without the appropriate driver installed, you will receive the error Required Microsoft driver is not installed. Install the Microsoft Access Database Engine driver For example, you can add them to the map, open them in the fields view, and use them as inputs to geoprocessing tools. You can open Microsoft Office Excel tables directly in ArcGIS Pro and work with them in the same way as other tabular data sources. Format a table in Microsoft Excel for use in ArcGIS Pro.Use Microsoft Excel files in ArcGIS Pro.Install the Microsoft Access Database Engine driver.