Latest Contributions by janehansen

I used wgs 84. Sent from my iPad ... View more

It did work thanks for sticking with me... Jane ... View more

Actually I did follow your steps. I imported the original spreadsheet as a table to the gdb...I used the field calculator to add a - in front of the long numbers. Then, I used this table to import into the x y fields of the add data. ... View more

Yes, it is the data I exported from my access mdb. I first importing the data without adding the - sign in front. I used add data added the long column to the x and the lat column to the y. I used wgs 84 as the coordinate system. The points displayed outside of BC. Then I added a - sign in front of the numbers in the long column by importing the table to a gdb and editing the column using the field calculator mulitply -1. Then I again followed the same process as above and the points still showed up outside of canada. I am trying to open the access mdb in arc cataloug and I can't get that to work either. I have added the the OLE connection and that has not helped. Thanks for sticking with me. Jane ... View more

Hi Abdullah, I should add that the original data base for this spread sheet is Access. I was not able to open the access database and import the shapefile so I exported the sheet to an excel format. Maybe the problems lies within the access database? I should have been able to open it using arc catalog but it didn't work. Thanks Jane ... View more

Yes did that too. Placed the Longitude column in the x box and the latitude in the Y. ... View more

Canada, NA BC to be more specific Zone 10 and 11 ... View more

I did use the gsc coordinate system for the lat and long columns. I tried NAD 83 and WBS 84. The points still showed up in the wrong place. Any other reason you can think of for this? Jane ... View more

Here is the attachement. The first one is from the original spreadsheet where I imported based on the longitude and latitude columns without the - in front of the longitude column. The points did not display in the right location. As you can see there are two other columns with x y coordinates. I imported any row with x y coordinates present and they all imported and displayed in the right location. Thanks for helping ... View more

I have now imported the points following the addition of the - in front of the longitude numbers. I used gsc wgs 1984 and the points are still showing up in the same place as when the - was not there...which is in the middle of the ocean What else could account for the points importing and presenting at the wrong location. Thanks ... View more

I did and it worked! Thanks guys:) ... View more

Thanks Adam and Abullah, I think you are both right. So I will import the table to a Geodatabse then use the field calculator to add a - in front of the number. Thanks for your help. Jane ... View more

Yes I am, and thanks I will give it a try ... View more