Saving Excel file in DBase IV format

C

CrawdadSolstice

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.
 
D

Doug Kanter

CrawdadSolstice said:
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?
 
C

CrawdadSolstice

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.
 
D

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.
 
C

CrawdadSolstice

Dave,

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

Doug Kanter

CrawdadSolstice said:
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?
 
C

CrawdadSolstice

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.
 
D

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.
 
C

CrawdadSolstice

Dave,

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

Doug Kanter

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top