Jump to content
Sign in to follow this  
alqamy

export Data

Recommended Posts

I have a geodatabase layer that have join to an excel sheet with matching records only option turned on to extract records matching a certain query. This resulted in 56 records to be available. When trying to export these to a separate layer as gdb or shapefiles I get a layer with 0 records in it. Can anybody help on how to over come this.

Share this post


Link to post
Share on other sites

Have you try to select all your feature and export it?

I don't know if you are using ArcGIS, but if it the case then I can tell you that time to time this bug happen.. specially with the 10.1 version.

 

;)

 

darksabersan.

Share this post


Link to post
Share on other sites

may be you could use this trick

 

personally I did not test this method yet, it is just crossed in my mind after I read your post

 

first, make an empty shapefile/feature class but set up the attribute table fields (and its field properties) matched your Excel table

 

then open your excel joined layer, start editing the previously created empty layer, 

 

then, using the Editor toolbar selection tool (black arrow without tail icon), select all the features in the excel joined layer, edit > copy and then paste it to the newly created empty layer.

 

hope it is works, 

Share this post


Link to post
Share on other sites

It could also be because of the field names of the joined data. Ensure that the column headings (which become field names) in your spreadsheet do not contain spaces or other funny characters. Although the join may happen successfully it will fail to export any records when exporting the joined dataset. Column names should not start with a number (0-9) but only text (A-Z).

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.