Select to view content in your preferred language

import of lines from a Excel/Access-table

1145
5
06-04-2012 05:45 AM
by Anonymous User
Not applicable
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
0 Kudos
5 Replies
by Anonymous User
Not applicable
Original User: pmcatnip

Here is a page that should help.
0 Kudos
by Anonymous User
Not applicable
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.
0 Kudos
MarcinGasior
Frequent Contributor
I think that for your data schema you can try XY To Line (Data Management) tool (Data Management -> Features -> XY To Line).
0 Kudos
by Anonymous User
Not applicable
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?
0 Kudos
MarcinGasior
Frequent Contributor
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).
0 Kudos