Subject Re: exporting .ods file in calc From Charlie <tm@tc.com> Date Thu, 28 Aug 2025 10:43:50 -0400 Newsgroups dbase.getting-started I think it failed because I was writing over a file.  I tried it again and it worked.  Thanks Lee! Charlie Wrote: > 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 > > > > > >