Excel --->db IV

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

THHAWK - 27 Feb 2008 15:51 GMT

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

Reply to this Message

Earl Kiosterud - 27 Feb 2008 22:39 GMT

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.

Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

>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
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

Gord Dibben - 27 Feb 2008 23:14 GMT

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

>>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
[quoted text clipped - 5 lines]
>>
>> How do I make the changes to th the header name stay?

Reply to this Message