Entry

Database: DBase: Spreadsheet: Excel: How to convert DBase .dbf file to Microsoft Excel .xls file?

Jul 29th, 2003 08:49
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- Tuesday 29 July 2003 --------------------------

Database: DBase: Spreadsheet: Excel: How to convert DBase .dbf 
database to Microsoft Excel .xls files?


Method 1: Rename your .dbf filename to a .xls filename

Steps: Overview:

 1. -Copy or rename your .dbf file to a .xls file

     1. to copy:

      e.g. type in an MSDOS box

       copy myfilename.dbf myfilename.xls

     2. to rename:

      e.g. type in an MSDOS box

       ren myfilename.dbf myfilename.xls

 2. -Load this .xls file in your Microsoft Excel

      e.g.

       1. -start Excel

       2. -select from menu option 'File'

       3. -select from list 'Open'

       4. -navigate to myfilename.xls

       5. -press the button to open it

---

Method 2: Use Microsoft FoxPro to do the conversion

Steps: Overview:

If you use Microsoft FoxPro v2.6 or higher:

 1. - load your .dbf file

 2. - use the following commands:

    use tablename

    copy tablename type xls

 3. - that will save your database in an Excel spreadsheet with
      extension .xls

 4. - load this .xls filename in your Microsoft Excel

----------------------------------------------------------------------