Subject Re: dBase 2019 how to save dbf as version 5 From Gaetano D. <gaetanoddRemoveThis@andThatHotmail.com> Date Thu, 27 May 2021 14:36:16 +1000 Newsgroups dbase.getting-started On 27/05/2021 14:10, Stuart Pacholko wrote: > Ken Mayer Wrote: > >> On 5/26/2021 8:21 PM, Stuart Pacholko wrote: >>> Hi >>> >>> I have dBase 2019. I need to create files in dBase 5 dbf format so they can be imported into MS Access. >>> >>> How do I set a dBase file version, or export to dbf 5 from dBase 2019 >> This would be done with dBASE closed, and then open the BDE Administrator. >> >> With the BDE Administrator open, click the "Configuration" tab, and on >> the treeview on the left, open Configuration if it's closed, open >> "Drivers", open "Native", click on "DBASE". On the right, see "LEVEL"? >> Click where it says "7" and change it to "5". Press Ctrl+A to apply >> changes and close the BDE Administrator. >> >> Start dBASE ... dBASE tables by default will be level 7 tables now. >> >> Ken >> >> -- >> *Ken Mayer* >> Ken's dBASE Page: http://www.goldenstag.net/dbase >> The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp >> dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm >> dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm >> dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm > Works fantastic! > > Thanks Ken > Is this Access 64-bit or 32-bit you are working with? It was my understanding that Microsoft had not released 64-bit drivers for dBase files, so I assume it is 32-bit? Just something to bear in mind if you (or the user) were thinking of moving to 64-bit Office. Also, instead of changing the DBE setting, why not export to CSV in dBase and import from CSV in Access? it would avoid changing the DBE settings back and forth. For a one-off, it's OK, but if you need to do it repeatedly, it would be a bit of a hassle compared to using a CSV format. Gaetano.