Hi all, I am looking for a way to create an automatic tool for importing excel tabular data(which are updated over time) in Arcmap using Model Builder tool. Is it possible to do it?

3127
4
11-30-2015 09:10 AM
DANIELAMATTINA
New Contributor

Hi all, I am looking for a way to create an automatic command for importing excel spreadsheets (which are updated over time) in Arcmap using Model Builder tool. Is it possible to do it? In that way I can run the model whenever new data are stored in tables excel. Many thanks, Daniela

0 Kudos
4 Replies
DarrenWiens2
MVP Honored Contributor

Have you tried (and do you have access to) the Excel to Table tool?

DANIELAMATTINA
New Contributor

Thanks for answer, No I haven't tried, as I would create an automatic model with model builder. I am using ArcGis 9.3

0 Kudos
DarrenWiens2
MVP Honored Contributor

I'm not sure what your options are in 9.3, but I don't believe Excel to Table existed then. Have you tried the Copy Rows tool?

I don't understand what you mean by you haven't tried the tool as you want to create an automatic model with model builder. I assume you will be using geoprocessing tools in your model?

0 Kudos
DANIELAMATTINA
New Contributor

yes I am using geoprocessing tool and through Model builder I would create

an automtic model for importing excel table which are updated every month.

Do you mean to cerate a model using the tool Copy rows in Model Builder? I

can try it and check the result.

Thanks

0 Kudos