Saving Excel file in DBase IV format

[Guest]

I have done this several times in the past, but don't do it often. I have an
Excel spreadsheet that I need to save in DBase IV format, but when I try, it
cu ts off all of the columns to the right of what I can see on the screen
when I go back into the DBF file. Any assistance on this would be greatly
appreciated.

 

[Doug Kanter]

I have done this several times in the past, but don't do it often. I have
an
Excel spreadsheet that I need to save in DBase IV format, but when I try,
it
cu ts off all of the columns to the right of what I can see on the screen
when I go back into the DBF file. Any assistance on this would be greatly
appreciated.

How many columns are in the original sheet?

 

[Guest]

Doug,

The original spreadhseet has 15 columns, of varying widths with all of the
header text entered. I eve went so far as to place a number in the second row
cells. Every time I save the file to the Dbase format, it is cut back to the
first three columns, the header names are shortened and the second row data
is gone.

Thanks for your response to my post.

 

[Dave Peterson]

Maybe...

Excel keeps track of the rows in your database file in a range name called
"Database"

You could delete it and excel will figure out what to use.

Or you could just change it to point at the new range.

Insert|names|define
is where you'd find either option.

 

[Guest]

Dave,

That did the trick. Thanks loads for your expert assistance. Now, if I can
only remember this for next time!!

 

[Doug Kanter]

Dave,

That did the trick. Thanks loads for your expert assistance. Now, if I can
only remember this for next time!!

How about creating a Word doc containing tips collected here?

 

[Guest]

Doug,

What would I do with the document I create? I think you have an excellent
idea, but want to be sure I am posting what you are asking fo in the proper
location.

 

[Doug Kanter]

Umm....give the doc a name you'll remember, like MyComputerProblems.doc, and
refer back to it for answers you've found over the years. As you suggested,
these problems tend to happen repeatedly, and it's sometimes hard to
remember how you fixed them a year ago.

 

[Guest]

Dave,

I wasn't trying to determine what to name the file, but where to post it
once I have it ready.

 

[Doug Kanter]

Oh boy. You don't post it. You save it on your hard disk so you can refer
back to it later.