Help! Can't check in an .axf!

Casey_Ragain

How can I extract the point data I collected in the .axf to an excel file?

Thanks!

QP_Result.jpg

AXF_Result.jpg

pop-up results.JPG

arcade.JPG

Anonymous User

Original User: e_hajek

Hi Casey,

The only way I know to do this is:

Open your .axf in ArcPad Studio.
Under "Feature Tables" right click on the feature class you want to extract to excel, and click Show Data.
Highlight all of it, copy, and paste into excel. It works perfectly for me in 2007, but you might have to do a "Paste Special..." and experiment with the options to get it to work.
You'll notice that the "Show Data" screen will only show you 1000 records at a time, so you have to alter the SQL statement at the top from:
SELECT * FROM [FEATURE_CLASS_NAME];    <-This will get the first 1000
to
SELECT * FROM [FEATURE_CLASS_NAME] WHERE AXF_OBJECTID BETWEEN 1000 AND 2000; <- This will get the next 1000
And click the red exclamation point on the right end of the toolbar along the top to execute the SQL command.

From there you can alter the data however you want in Excel for use in ArcMap via Joins based on ObjectID or whatever.

This was really helpful for me when I realized after the field work was over that the timestamps were needed for calibration.

Hope this helps,
Eric