Saving Excel file in DBase IV format

#1 03-20-2006, 10:45 AM

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.

#2 03-20-2006, 11:10 AM

"CrawdadSolstice" <CrawdadSolstice@discussions.microsoft.com> wrote in
message news:02B85222-66D2-4C95-B5BD-9F587ED1DCFC@microsoft.com...
>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?

#3 03-20-2006, 02:10 PM

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.

"Doug Kanter" wrote:

>
> "CrawdadSolstice" <CrawdadSolstice@discussions.microsoft.com> wrote in
> message news:02B85222-66D2-4C95-B5BD-9F587ED1DCFC@microsoft.com...
> >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?

#4 03-20-2006, 02:45 PM

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.

CrawdadSolstice wrote:
>
> 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.

--

Dave Peterson

#5 03-20-2006, 04:10 PM

Dave,

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

"Dave Peterson" wrote:

> 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.
>
> CrawdadSolstice wrote:
> >
> > 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.
>
> --
>
> Dave Peterson
>

#6 03-20-2006, 04:15 PM

"CrawdadSolstice" <CrawdadSolstice@discussions.microsoft.com> wrote in
message news:443575FD-382E-478F-9B00-AFF937E9BC61@microsoft.com...
> 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?

#7 03-20-2006, 04:25 PM

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.

"CrawdadSolstice" <CrawdadSolstice@discussions.microsoft.com> wrote in
message news:DF708473-8507-4596-A9D7-F8D2652EAA44@microsoft.com...
> 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" wrote:
>
>> "CrawdadSolstice" <CrawdadSolstice@discussions.microsoft.com> wrote in
>> message news:443575FD-382E-478F-9B00-AFF937E9BC61@microsoft.com...
>> > 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?
>>
>>
>>

#8 03-20-2006, 04:25 PM

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" wrote:

> "CrawdadSolstice" <CrawdadSolstice@discussions.microsoft.com> wrote in
> message news:443575FD-382E-478F-9B00-AFF937E9BC61@microsoft.com...
> > 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?
>
>
>

#9 03-20-2006, 05:25 PM

Dave,

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

"Doug Kanter" wrote:

> 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.
>
>
> "CrawdadSolstice" <CrawdadSolstice@discussions.microsoft.com> wrote in
> message news:DF708473-8507-4596-A9D7-F8D2652EAA44@microsoft.com...
> > 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" wrote:
> >
> >> "CrawdadSolstice" <CrawdadSolstice@discussions.microsoft.com> wrote in
> >> message news:443575FD-382E-478F-9B00-AFF937E9BC61@microsoft.com...
> >> > 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?
> >>
> >>
> >>
>
>
>

#10 03-20-2006, 05:45 PM

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

"CrawdadSolstice" <CrawdadSolstice@discussions.microsoft.com> wrote in
message news:5593CFBF-BCA1-4557-BAFD-B50D5770993A@microsoft.com...
> Dave,
>
> I wasn't trying to determine what to name the file, but where to post it
> once I have it ready.
>
> "Doug Kanter" wrote:
>
>> 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.
>>
>>
>> "CrawdadSolstice" <CrawdadSolstice@discussions.microsoft.com> wrote in
>> message news:DF708473-8507-4596-A9D7-F8D2652EAA44@microsoft.com...
>> > 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" wrote:
>> >
>> >> "CrawdadSolstice" <CrawdadSolstice@discussions.microsoft.com> wrote in
>> >> message news:443575FD-382E-478F-9B00-AFF937E9BC61@microsoft.com...
>> >> > 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?
>> >>
>> >>
>> >>
>>
>>
>>

gygulyas · #11 07-02-2009, 01:54 PM

XLSX2DBF is an Excel 2007 add-in that helps convert and/or save a native DBF file that was edited with Excel 2007.

Two common scenarios are supported:

A) Open a native DBF file in Excel 2007 – Make changes – Save as a native DBF file with the changes.

B) Open/create an Excel file that looks like a database (headers/columns/rows) – Save as a native DBF file.

http://thexlwiz.blogspot.com/

Gyula

Welcome to the Excel Forum

Forum Statistics