Converting an Excel Spreadsheet to an Access 2010 Database
By Mike Chapple, About.com Guide
5 of 9
Select Column Headings
Often, Microsoft Excel users utilize the first row of their spreadsheet to provide column names for their data. In our example file, we did this to identify the Last Name, First Name, Address, etc. columns. In the window shown above, ensure that the "First Row Contains Column Headings" box is checked. This will instruct Access to treat the first row as names, rather than actual data to be stored in the list of contacts. Click the Next button to continue.