Subject Re: exporting .ods file in calc
From Charlie <tm@tc.com>
Date Thu, 28 Aug 2025 09:34:07 -0400
Newsgroups dbase.getting-started

Thanks Lee...  I tried that setting but it must be something else as I got the same result.  Using dbase 11 I actually use a different setting than that one and it works.  Evidently it must be something else and not a road block for 2019.

Lee Grant Wrote:

> Sorry Charlie,
>
> (I had to do that, in reference to Charlie the Tuna. :)  )
>
> I just opened an OpenOffice calc sheet, in Libre Office Calc, and then
> Saved As, into a .dbf file.  Went to dBASE 2019, and opened the
> file...no problem.
>
> Now, that being said, the Libre Office TRIED to save it as "Western
> Europe(DOS/OS2-850/International)" Character set, which was weird to me.
>   I had to manually make it go to the bottom of the list and save as
> "Western Europe(Windows-1252/WinLatin1)" Character set.  That may be
> your problem, as I'm unaware of whether or not, dBASE will understand be
> able to read any other character set from Libre Office.
>
> Lee
>
> On 8/27/2025 3:26 PM, Charlie wrote:
> > Charlie Wr
> >
> > Wow this failed in dbase 2019, but works with the headers correct in dbase 11.  Did something change with 2019 to make this fail?  Or is there something I need to change in 2019??
> >
> >> I am trying to export an .ods spreadsheet file into dbase.  Libre allows this as an easy way to make a dbase .dbf from an .ods or xlsx file.  I have done this before successfully.  This time instead of the first line of the spreadsheet becoming field names, the field names are the headers of the spreadsheet such as a b c d......    I may have had this problem a long time ago and fixed it somehow.  Anyone have a clue on this?   Thanks
> >
>