I have an incomplete data table that is part of a .shp file (it was entirely created in Map 3d). I also have an excel file with the complete data. The column headings on each file are the same. How can I connect the excel file to fill in the missing info from the data table? I have tried creating an ODCB connection through the System DSN. I used defined names in excel for each of my column headings. Then I connected to the ODCB and tried to create a join between the tables. When I do this no additional data from the excel file shows up in the data table. Is there another method or could I be doing something wrong?
Thanks