topic Re: import of lines from a Excel/Access-table in Data Management Questions

import of lines from a Excel/Access-table

Anonymous User — Mon, 04 Jun 2012 12:45:33 GMT

Original User: MagnusP

hello community,

i have a table (Excel/Access). This should be produced in a line-layer. In the table there is a column with an ID, two with the X and Y coordinates of the starting point and two with the X and Y coordinates of the end point of the line.

I would like to embed this table now so that I can see and use the lines in ArcGIS.

thanks

MagnusP

Re: import of lines from a Excel/Access-table

Anonymous User — Mon, 04 Jun 2012 21:34:04 GMT

Original User: pmcatnip

Here is a page that should help.

Re: import of lines from a Excel/Access-table

Anonymous User — Tue, 05 Jun 2012 08:03:19 GMT

Original User: MagnusP

Thanks for your quickly answer,

with the funktion �??Add XY Data�?�, what is described in your link, I can import only points. What i need is the import of linestrings defined of two points.

In my ArcGIS is now an dbf-file included. It contains an ID, an attribute, an X- and Y- coordinate of an startingpoint an the X- and Ycoordinate of the Endpoint. The problem is the figure/mapping of the line.

Re: import of lines from a Excel/Access-table

MarcinGasior — Tue, 05 Jun 2012 08:18:51 GMT

I think that for your data schema you can try XY To Line (Data Management) tool (Data Management -> Features -> XY To Line).

Re: import of lines from a Excel/Access-table

Anonymous User — Tue, 05 Jun 2012 09:42:17 GMT

Original User: MagnusP

oh, thanks a lot. It looks very nice.

But tell me where i can type and execute this code. (adapted codes sample).
If it is possible, please describe a short procedure.

Is ist VBA?

Re: import of lines from a Excel/Access-table

MarcinGasior — Tue, 05 Jun 2012 10:01:06 GMT

If you have only one table to process, you don't need to use a code - just run the tool from toolbox (Data Management -> Features -> XY To Line; or type "XY to line" in Search window).

Anyway, to execute a code you can use Python window in ArcMap/ArcCatalog or standalone application like IDLE (which is installed with ArcGIS).