|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | Re: [gislist] Dumb DBF question |
| Date: |
05/09/2006 12:05:02 PM |
| From: |
Emily Smith |
|
|
Here's another thing you can do. After you make sure your columns are
formatted (if numbers are left as "general" your decimal places will be
lost), click on Insert-Name-Define in order to open up a dialog box that
defines the extent of your data. The data range will probably be the same
as the original excel file before you added the extra rows or columns of
data for your DBF file. Just include the extended area in your selection,
and then you can save the file as a DBF without having to copy/paste to a
new worksheet.
-Emily
At 12:13 PM 5/9/2006 -0400, humberto Perotto wrote:
>Larry,
>
>I have had this problem in the past. What I do is to copy the data into a
>new spreadsheet and paste it as values. Then I make sure that the columns
>that are numbers are displayed as numbers with the number characters after
>the comma, and finally I highlight the whole data region I want and then I
>save that as my new dbf file. Tha works for me, but if there is an easier
>way to do it, that would be great!
>
>Cheers
>
>Humberto
_________________________________________________
I need to do an analysis on some data in a DBF-but after I have run
calculations in Excel and pop it back into DBF, the data isn't showing
up in the DBF.
Larry Holt
Director of Research
Birmingham Regional Chamber of Commerce
_______________________________________________
gislist mailing list
gislist@lists.geocomm.com
http://lists.geocomm.com/mailman/listinfo/gislist
_________________________________
This list is brought to you by
The GeoCommunity
http://www.geocomm.com/
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
