software

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.


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

How many columns are in the original sheet?
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.

quot;Doug Kanterquot; wrote:

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

Excel keeps track of the rows in your database file in a range name called
quot;Databasequot;

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.

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

--

Dave Peterson

Dave,

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

quot;Dave Petersonquot; wrote:

gt; Maybe...
gt;
gt; Excel keeps track of the rows in your database file in a range name called
gt; quot;Databasequot;
gt;
gt; You could delete it and excel will figure out what to use.
gt;
gt; Or you could just change it to point at the new range.
gt;
gt; Insert|names|define
gt; is where you'd find either option.
gt;
gt; CrawdadSolstice wrote:
gt; gt;
gt; gt; I have done this several times in the past, but don't do it often. I have an
gt; gt; Excel spreadsheet that I need to save in DBase IV format, but when I try, it
gt; gt; cu ts off all of the columns to the right of what I can see on the screen
gt; gt; when I go back into the DBF file. Any assistance on this would be greatly
gt; gt; appreciated.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

quot;CrawdadSolsticequot; gt; wrote in
message ...
gt; Dave,
gt;
gt; That did the trick. Thanks loads for your expert assistance. Now, if I can
gt; only remember this for next time!!

How about creating a Word doc containing tips collected here?
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.

quot;Doug Kanterquot; wrote:

gt; quot;CrawdadSolsticequot; gt; wrote in
gt; message ...
gt; gt; Dave,
gt; gt;
gt; gt; That did the trick. Thanks loads for your expert assistance. Now, if I can
gt; gt; only remember this for next time!!
gt;
gt; How about creating a Word doc containing tips collected here?
gt;
gt;
gt;

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.quot;CrawdadSolsticequot; gt; wrote in
message news
gt; Doug,
gt;
gt; What would I do with the document I create? I think you have an excellent
gt; idea, but want to be sure I am posting what you are asking fo in the
gt; proper
gt; location.
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt; quot;CrawdadSolsticequot; gt; wrote in
gt;gt; message ...
gt;gt; gt; Dave,
gt;gt; gt;
gt;gt; gt; That did the trick. Thanks loads for your expert assistance. Now, if I
gt;gt; gt; can
gt;gt; gt; only remember this for next time!!
gt;gt;
gt;gt; How about creating a Word doc containing tips collected here?
gt;gt;
gt;gt;
gt;gt;
Dave,

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

quot;Doug Kanterquot; wrote:

gt; Umm....give the doc a name you'll remember, like MyComputerProblems.doc, and
gt; refer back to it for answers you've found over the years. As you suggested,
gt; these problems tend to happen repeatedly, and it's sometimes hard to
gt; remember how you fixed them a year ago.
gt;
gt;
gt; quot;CrawdadSolsticequot; gt; wrote in
gt; message news
gt; gt; Doug,
gt; gt;
gt; gt; What would I do with the document I create? I think you have an excellent
gt; gt; idea, but want to be sure I am posting what you are asking fo in the
gt; gt; proper
gt; gt; location.
gt; gt;
gt; gt; quot;Doug Kanterquot; wrote:
gt; gt;
gt; gt;gt; quot;CrawdadSolsticequot; gt; wrote in
gt; gt;gt; message ...
gt; gt;gt; gt; Dave,
gt; gt;gt; gt;
gt; gt;gt; gt; That did the trick. Thanks loads for your expert assistance. Now, if I
gt; gt;gt; gt; can
gt; gt;gt; gt; only remember this for next time!!
gt; gt;gt;
gt; gt;gt; How about creating a Word doc containing tips collected here?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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

quot;CrawdadSolsticequot; gt; wrote in
message ...
gt; Dave,
gt;
gt; I wasn't trying to determine what to name the file, but where to post it
gt; once I have it ready.
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt; Umm....give the doc a name you'll remember, like MyComputerProblems.doc,
gt;gt; and
gt;gt; refer back to it for answers you've found over the years. As you
gt;gt; suggested,
gt;gt; these problems tend to happen repeatedly, and it's sometimes hard to
gt;gt; remember how you fixed them a year ago.
gt;gt;
gt;gt;
gt;gt; quot;CrawdadSolsticequot; gt; wrote in
gt;gt; message news
gt;gt; gt; Doug,
gt;gt; gt;
gt;gt; gt; What would I do with the document I create? I think you have an
gt;gt; gt; excellent
gt;gt; gt; idea, but want to be sure I am posting what you are asking fo in the
gt;gt; gt; proper
gt;gt; gt; location.
gt;gt; gt;
gt;gt; gt; quot;Doug Kanterquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; quot;CrawdadSolsticequot; gt; wrote in
gt;gt; gt;gt; message ...
gt;gt; gt;gt; gt; Dave,
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; That did the trick. Thanks loads for your expert assistance. Now, if
gt;gt; gt;gt; gt; I
gt;gt; gt;gt; gt; can
gt;gt; gt;gt; gt; only remember this for next time!!
gt;gt; gt;gt;
gt;gt; gt;gt; How about creating a Word doc containing tips collected here?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;