Browse » Home
Wednesday, February 20, 2013
How to Convert Excel 2007 to Dbf
1. Download a converter program designed to save Excel 2007 files to dbf format. There are a number of such programs on the market. Some of them are free and others are available at a reasonable cost. Please see the Resources section for links to some of these converter programs.
2. Open Microsoft Excel 2007 and create the spreadsheet you want to convert. Save the file in Excel 2007 format to your hard drive or to your network shared drive.
3. Close the Excel spreadsheet and open your conversion program. Choose 'import data into database.' You can choose to import the data from the Excel 2007 spreadsheet into a database you have already opened, or you can import the data into a database file on your hard drive or network share.
4. Click 'OK' to begin the import process. Choose the appropriate format for each field in the spreadsheet, i.e. text for labels and notes and currency for pricing data.
5. Close the converter program and open your database program. You can open the dbf file you have created in Microsoft Access or dBase. Review the data to make sure all of the fields were imported successfully.