copying a view

Question

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]

_paste2PGDB.png

_paste2FGDB.png

HaniuHokkaido · Answer

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

Anonymous User · Answer

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.