Link To Excel Spreadsheets

Short Description
Relate Excel data and formula results to elements in your TNT spatial objects … Use Theme Maps to graphically display the results from Excel formulas …

Website: www.microimages.com | Filesize: 47kb

Content
Link to Excel Spreadsheets
How to Link to an Excel Spreadsheet
?Maintain attributes and build complex formula fields in an Excel spreadsheet
?Get a table representation for each sheet in the Excel file
?Relate Excel data and formula results to elements in your TNT spatial objects
?Show Excel formula results as DataTips
?Use Theme Maps to graphically display the results from Excel formulas
?Update and save Excel formulas while viewing the linked TNT objects
?Make sure the Excel file contains a field with unique values corresponding to
those in a native TNT table in your spatial object’s database.
?In the Import process, select your Excel file and choose the EXCEL format.
?Turn on the Link Only toggle in the Import Parameters window.
?Select the element database in the TNT spatial object to contain the linked
representation of the Excel file.
?After the link is made, use the Database Editor to relate the linked table to a
TNT table that is attached to the spatial elements.
?To use TNT and Excel concurrently, open the Excel spreadsheet first.
DID YOU KNOW . . . you can link Excel Spreadsheet data…