The MCHP GIS MANUAL - Dbase Files

         

Introduction   Contents


 USING ArcGIS: 
   
1. Basic Use of ArcMap 
   Creating a Map 
   Data Frame Tools
   Data Frame Properties
   Tables and Charts
   Layout View
   Saving Map Documents
   Activity 1

2. Map Projections
   Projections
   UTM
   Datums
  
3. ArcCatalog 
   Basic Uses    
   
4. ArcToolBox 
   Basic Uses    
   
5. Adding Spatial Information
   Georeferencing
   Adding Non-Spatial Data
   Dbase Files
   Activity 2

6. Selecting Data
   By Graphics
   By Location
   Activity 3

7.  Exporting Maps
   Exporting
   Activity 4
  
 
FURTHER INFORMATION:
   General Information
   Data Sets

Dbase FILES

Microsoft Help for Excel has this to say about saving Dbase files:

Only data in the named range or current region is saved. When you save an Excel worksheet in dBASE (DB2, DB3, or DB4) format and the worksheet contains a range named "Database," only data in the named range is saved in the dBASE file. If you add new records after naming the range, you must redefine the database range to include the new records before you save the sheet in dBASE format.

If there is no range named "Database" on the sheet, only data in the current region is converted. If the first row of data contains text, Excel uses it as the header row to define field names. If the first row contains all numbers, Microsoft Excel creates field names such as N1, N2, and so on.

Make sure character strings are shorter than column width When saving data in dBASE format, Excel assigns a data type to each field (column of data) that is based on the field data in the first record of the database range or current region.

If a field in the first record contains text, that field is assigned the character data type, and any numbers contained in the field in other rows become character strings. The column width of the field determines the string length; character strings longer than the column width are truncated in dBASE. To prevent losing data, select the range you want to convert in Excel, and apply a monospaced font such as Courier. To size the columns to show all the data, point to Columns on the Format menu, and then click AutoFit Selection. Numeric data fields cannot contain text; any text in a numeric data field becomes null.

Use a number format other than General If decimal numbers have the General number format, the decimal places are truncated in dBASE. Before you save the data in dBASE format, apply a different number format to all data in that field. On the Format menu, click Cells, and then click the Number tab. In the Category box, click Number or Scientific, and then specify the number of decimal places you want.

Change time data to text data Fields that contain time data cannot be converted. Before you save data in dBASE format, you can change time data to text data by using the TEXT worksheet function. For example, to change the time 12:34 PM to text data, use the function =TEXT("12:34", "hh:mm AM/PM").

Adding Non-Spatial Data  

Contact: Charles Burchill       Telephone: (204) 789-3429

Manitoba Centre for Health Policy
Department of Community Health Sciences, University of Manitoba
4th floor Brodie Centre
408 - 727 McDermot Avenue
Winnipeg, Manitoba R3E 3P5       Fax: (204) 789-3910
Last modified on Friday, 25-Aug-2006 08:06:00 CDT