Excel --->db IV

T

THHAWK

I have a geocoding program that requires me to save my spreadsheet to a db IV
file in order to import it into the program and process. The problem is
this: I have to set the column with zip codes to a required fixed width of 5
AND it must be named "ZIP". I set the width to 5 and change the header name
to 'ZIP' and then save as db IV. When I reopen it, the header name is no
longer 'ZIP' (the cell content remains 'ZIP', but the name box has changed
back to the default of 'H1'.

How do I make the changes to th the header name stay?

Thanks
 
E

Earl Kiosterud

I don't have DB IV, but with a typical database table in Excel, you have the field names in
the first row, not the name box. Put ZIP in cell H1 and see what happens. The first actual
record will be in row 2, etc.
 
G

Gord Dibben

Typing ZIP in the top row of a column does name that column.

Maybe you should select the column and Insert>Name>Define.

Name it ZIP and OK out.

Type ZIP in row 1 of the colulmn

Now both namebox and cell will read ZIP


Gord Dibben MS Excel MVP
 
Top