Importing from Spreadsheet into Access 2000/2002

Part 1: Import or link data from a spreadsheet

Before you proceed, make sure that the data in the spreadsheet is arranged in an appropriate tabular format, and that the spreadsheet has the same type of data in each field (column) and the same fields in every row.

1. Open a database, or switch to the Database window for the open database.
2. To import a spreadsheet, on the File menu, point to Get External Data, and then click Import.
3. In the Import dialog box, in the Files of type box, select Microsoft Excel (*.xls) or Text File (*.csv).
4. Click the arrow to the right of the Look in box, select the drive and folder where the spreadsheet file is located, and then double-click its icon.
5. Follow the directions in the Import Spreadsheet Wizard dialog boxes. If you are importing from a Microsoft Excel version 5.0 or later workbook, then you can import from one worksheet within a workbook. You cannot import from any other multiple-spreadsheet files, such as Microsoft Excel version 4.0 workbooks. To import from these files, you must first save each spreadsheet as an individual file.

Part2: Convert an Access file to a previous version

You can convert a Microsoft Access database in Access 2000 or Access 2002 file format back to Access 97.

1. Open the Microsoft Access file that you want to convert. If it is a multiuser Access database that is located on a server or in a shared folder, make sure that no one else has it open.
2. On the Tools menu, point to Database Utilities, click Convert Database, and then click the file format you want.
3. In the Convert Database Into dialog box, type the name of the new previous-version database that you want to create in the File name box, and then click Save.

If you have any questions, contact our technical support department: support@mainsequence.net or (440) 946-5214

This document is provided for information only. The information contained in this document is the position of Main Sequence Technologies as of the date of publication. This information is not a promise or guarantee nor is the accuracy of any information generated after this item is published guaranteed.

This document is provided AS IS without warranty of any kind, express or implied, including but not limited to merchant ability, fitness for a particular purpose, and freedom from infringement.