topic Re: Create ling from point (XLSX) in ArcGIS Pro Questions

Create ling from point (XLSX)

AliAzzouhri1 — Sun, 14 Jul 2019 13:25:48 GMT

Hi everyone I want to create a line from this XLSX file but I can't Upload to Arcgis it shows a message error, thank you...

Re: Create ling from point (XLSX)

DanPatterson_Retired — Sun, 14 Jul 2019 13:36:10 GMT

The error message would be useful.

And were you using the

Excel To Table—Conversion toolbox | ArcGIS Desktop

tool from ArcToolbox?

Re: Create ling from point (XLSX)

AliAzzouhri1 — Sun, 14 Jul 2019 13:45:33 GMT

This is the error message...

Re: Create ling from point (XLSX)

LanceCole — Sun, 14 Jul 2019 15:00:27 GMT

Ali,

Take a look at Understanding how to use Microsoft Excel files in ArcGIS—Help | ArcGIS Desktop.

Even thought you have Excel installed you need to install the Microsoft Access Database Engine 2010 Redistributableas Microsoft has discontinued support for the Office 2007 drivers noted in the article. This package will install a set of components that can be used to facilitate transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications. You might need to exit ArcGIS and excel for this to work after installing.

One other note, I believe you need to download and install the 32-bit version of the Microsoft Access Database Engine 2010 Redistributable even for 64-bit systems on ArcGIS Desktop and Pro.

Re: Create ling from point (XLSX)

JoshuaBixby — Sun, 14 Jul 2019 15:22:17 GMT

Another approach, given your worksheet has a simple structure, is to export the Excel worksheet as a CSV file and then use native ArcGIS connection to the CSV file to import data.