Many spreadsheet users take advantage of the database features in Microsoft Excel when working with their spreadsheet data. Simple search, sort and filter functions are available using the “Data” menu within Excel. Microsoft Access is a full-featured, relational database that is compatible with Microsoft Excel. Importing Excel spreadsheet data into Microsoft Access provides several benefits, including improved data input, multiuser access and advanced reporting options. Excel column data labels are converted to field names, column data is converted to fields and each row is converted to a record during the import process. Tips Warnings Writer Bio
