I have a list of aprox 150 unique road names in excel. I copy and paste (as text option) that list into word (2013 version). I then "replace" all the end paragraphs (^p) with quotes and commas (','). This gets the list to go from:
Cambie
Blanchard
Cook
to looking like 'Cambie','Blanchard','Cook'
Then within arc's select by attribute I use this text in the query Road_Name IN ('Cambie','Blanchard','Cook') which gives me an SQL error. Any idea why I would be getting the error? Any suggestions as to how I can easily select by 150 road names from an attribute table of aprox 1000.
أكثر...
Cambie
Blanchard
Cook
to looking like 'Cambie','Blanchard','Cook'
Then within arc's select by attribute I use this text in the query Road_Name IN ('Cambie','Blanchard','Cook') which gives me an SQL error. Any idea why I would be getting the error? Any suggestions as to how I can easily select by 150 road names from an attribute table of aprox 1000.
أكثر...