How to Export Excel 2007 to a Works Database

Install the Microsoft Office Compatibility Pack
1. Go to the Microsoft Office Compatibility Pack for Word, Excel and PowerPoint File Formats page (see Resources).
2. Scroll down to the 'Quick Details' section and choose the language for the file you would like to download by clicking the down arrow next to the 'Change Language:' label and making your selection. Click the blue 'Download' button and save the 'FileFormatConverters.exe' file to your computer.
3. Click the down arrow next to the 'Estimated Download Time' label to choose the speed of the Internet connection you are using.
4. Read through and (if necessary) follow the instructions in the 'Overview' and 'System Requirements' sections to be sure your program will function properly once installed.
5. Click 'Start,' type 'Windows Update' and press 'Enter.' Click 'Check for updates' in the Windows Update window that opens and install all recommended software to bring your system up to date. If Windows Update does not recommend software, it is because your computer is already up to date.
6. Open the 'FileFormatConverters.exe' file you saved and follow the instructions given to install the program on your computer.Use the following instructions to save the file in CSV format if you have Excel on your computer and you do not want to install the Microsoft Office Compatibility Pack.
7. Open the file in Excel that you want to transform and click the 'Office' button, select 'Save As' and then 'Other Formats.'
8. Select the downward arrow next to the 'Save as type' label in the 'Save As' dialog box and scroll to find 'CSV (Comma delimited) (*.csv)' and select it. Click the 'Save' button. Save one sheet at a time if saving data from multiple sheets in a workbook. If you are using this method, use the CSV file instead of the Excel file for the conversion.
Convert the Excel Spreadsheet to a Works Spreadsheet
9. Click 'Start' and navigate to the file you want to convert. Right-click on the file, select 'Open with,' then select 'Choose Program' to open the 'Open With' window.
10. Scroll through the list to find 'Microsoft Works.' If it is there, select it and click the 'OK' button to close the 'Open With' dialog box and open the file in the selected program.If you did not find Microsoft Works listed in the 'Open With' dialog box, find the Microsoft Works program and click the 'wksss.exe' file, then click 'OK' to close the dialog box and open the file in the selected program.
11. Click on 'File' on the top menu in Works and select 'Save As.' Be sure the 'Save as type' option is set to Works format. The extension will be '.wps.'
12. Name the document and click the 'Save' button.
Create the Works Database
13. Click cell A1 (the top-left cell in the spreadsheet) and hold down the 'Ctrl' and 'Shift' keys and press the 'End' key to select the active cell range in the workbook.
14. Click 'Edit' on the top menu and select 'Copy' to copy the cells you want to include in your database.
15. Click 'File' on the top menu and select 'New' and then click 'Add to a Field' to create a new database.
16. Click 'Edit' on the top menu and click 'Paste' and click 'Yes' to let Works add extra fields.