Friday, April 22, 2011

How to Convert Excel 2007 Files to dBase


1. Find out what formats the database you're importing into can accept. Nearly all of them can take comma-separated values (CSV), and many can accept legacy Excel formats, such as XLS.
2. Click the 'Office' button (the round button at the upper left with the Microsoft Office logo on it). On the menu that pops up, select 'Save As.'
3. Select the appropriate file type (either CSV or XLS) from the drop-down menu at the bottom of the dialog box that opens up. Click on the 'Save' button.
4. Import the file in dBase or FoxPro to make sure that everything worked appropriately and the data is in the right place.

Blogger news