topic copying a view in Data Management Questions

copying a view

Anonymous User — Thu, 04 Jul 2013 09:26:00 GMT

Original User: haniu_ntt

Hi,

I want to copy a view to FGDB or PGDB. Both failed.
Why ? Cant view be copied ?

Thanks

_paste2FGDB.png
_paste2PGDB.png

[SQL Server 2005, ArcSDE 10.0]

Re: copying a view

Anonymous User — Thu, 04 Jul 2013 22:51:38 GMT

Original User: crafty762

I am not certain why this is failing, but one thing you could do is export your view to an Excel spreadsheet and then import it into the FGDB or PGDB after the fact. This method might work well if you only need to do this a few times here and there. Another option is to create an empty table in your FGDB or PGDB with the correct field definitions and then load the data values in using the Simple Data Loader in ArcCatalog.

Re: copying a view

HaniuHokkaido — Fri, 05 Jul 2013 00:08:27 GMT

I am not certain why this is failing, but one thing you could do is export your view to an Excel spreadsheet and then import it into the FGDB or PGDB after the fact. This method might work well if you only need to do this a few times here and there. Another option is to create an empty table in your FGDB or PGDB with the correct field definitions and then load the data values in using the Simple Data Loader in ArcCatalog.

yes.thanks. the load works fine. i am just wondering why the copying fails ?

thanks again