If you have data in an Excel spreadsheet, you can use the information in an Access database. You can import or link all the data from a spreadsheet or specific data from a named range. When you import or link data, Access normally creates a new table for the information. For Excel spreadsheet data, you can also append data to an existing table as long as the table field's and spreadsheet column headings match. After you import or link data, you should check to make sure Access assigned the appropriate data type to the imported fields. Import or Link Data from an Excel Spreadsheet
|