How do I save an Excel file in dBASE III format so that I can import it into DesignPro?
Follow these steps to save an Excel file in dBASE III format: 1. Open the Excel database file. 2. Review the spreadsheet. The spreadsheet must be set up correctly for a successful conversion to dBASE III format. Verify that the information you want is on the first worksheet only; the field names are in the first row and begin in Row 1, Column A; the entries begin in Row 2; and the column widths are wide enough to display all of the text in the columns. 3. In Excel, select File > Save As. In the Save As dialog box, select the location for the dBASE version of your file and rename it, if desired. From the Save as type pull-down list box, select DBF 3 (dBASEIII). Click Save. 4. A message appears notifying you that the selected file type does not support workbooks that contain multiple sheets. Click OK to save the file in dBASE III format. 5. Close the Excel file. You may receive another Microsoft Excel message at this time. Select the option that will keep the existing file format without
