You are here: > ESRI Forums > arcgis desktop discussion forums > Thread Replies

ArcGIS Desktop Discussion Forums

ArcGIS Desktop - Data Management (General) forum

Non-Display of XY data from Access table   Rebecca Briscoe Oct 19, 2007
Re: Non-Display of XY data from Access tabl...   Dan Patterson Oct 19, 2007
Re: Non-Display of XY data from Access tabl...   Rebecca Briscoe Oct 19, 2007
Re: Non-Display of XY data from Access tabl...   Dan Patterson Oct 19, 2007
Re: Non-Display of XY data from Access tabl...   Rebecca Briscoe Oct 19, 2007
Re: Non-Display of XY data from Access tabl...   Dan Patterson Oct 19, 2007
Re: Non-Display of XY data from Access tabl...   Rebecca Briscoe Oct 19, 2007
Re: Non-Display of XY data from Access tabl...   Star Lakavage Apr 24, 2008
Re: Non-Display of XY data from Access tabl...   Kerry Jones May 17, 2010
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Non-Display of XY data from Access table 
Author Rebecca Briscoe 
Date Oct 19, 2007 
Message Dear all,

Hoping you can help as I'm at my wit's end trying to display XY data from an Access database table in ArcView 9.1.

There is no error message and, as recommended in the helpfiles / forums, I have tried

- changing the field names
- checking the field types
- adding new columns and copying the data over
- double checking the co-ordinate system of the dataview

Any ideas gratefully received!

Rebecca 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Non-Display of XY data from Access table 
Author Dan Patterson 
Date Oct 19, 2007 
Message can you post a few records including the field names 
  Geomatics, Carleton University, Ottawa, Canada 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Non-Display of XY data from Access table 
Author Rebecca Briscoe 
Date Oct 19, 2007 
Message certainly what is the easiest form for you to view?

I have attached an export from the database in dbf 5 format. Please let me know if you require another format.

Easting and Northing are (unsurprisingly) the two fields I wish to plot.

Rebecca 
  TEST DAT.DBF (opens in new window)
TEST DAT.DBT (opens in new window)
TEST DAT.MDX (opens in new window)
 
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Non-Display of XY data from Access table 
Author Dan Patterson 
Date Oct 19, 2007 
Message arcgis supports dbase IV or csv
the other file just gives errors 
  Geomatics, Carleton University, Ottawa, Canada 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Non-Display of XY data from Access table 
Author Rebecca Briscoe 
Date Oct 19, 2007 
Message my apologies, please find attached the same file in .dbf version IV... 
  TEST DAT.DBF (opens in new window)
TEST DAT.DBT (opens in new window)
TEST DAT.MDX (opens in new window)
 
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Non-Display of XY data from Access table 
Author Dan Patterson 
Date Oct 19, 2007 
Message I couldn't even bring either set into access, can you zip the data in several formats (ie delimited text, dbase IV, just the *.dbf file) so I can try on other programs 
  Geomatics, Carleton University, Ottawa, Canada 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Non-Display of XY data from Access table 
Author Rebecca Briscoe 
Date Oct 19, 2007 
Message Thanks for your time over this, sorry it's been such a faff. A colleague has managed to convert the original excel data to .txt and plot the XY that way to send me a .shp, so the query has been resolved.

Interestingly, my computer will still not import/ plot the data this way - obviously the gremlins are making their presence felt today :o)

cheers,
Rebecca 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Non-Display of XY data from Access table 
Author Star Lakavage 
Date Apr 24, 2008 
Message Rebecca
did you ever figure the problem out with displaying xt data from an Access table and the data not displaying? A colleague had the same problem today. He had records in an Access table, had valid easting/northings and whenever he did the Display XY, he never got an event theme.

We created a geodatabase, imported the Access table, and tried that but it still wouldn't work. Yet, I was able to Display xy from the same geodatabase on my workstation.

Thanks,
Star Lakavage 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Non-Display of XY data from Access table 
Author Kerry Jones 
Date May 17, 2010 
Message 2 years later and now I am having that exact same problem. Did you get anywhere with this?

I have tried MS-Access97, 2000, 2003 and 2007
and in each case nothing happens. Not even an error message. It works fine from Excel Spreadsheet.

Kerry Jones
Department of Conservation,
New Zealand.