How+to+import+a+Spreadsheet+from+excel+to+access

1. Open Access to a new database. 2. Go to the External Data tab, and select excel from the import group. 3. Click browse on the file name box and find the excel document that you want to import and hit ok afterwards.
 * Note**- Access will show you a sample worksheet of the file that you have selected.

4. Select one worsheet or range from your spreadsheet. 5.After that, check the box if your spreadsheet has headings on the top.

6. Next, you can scroll left and right to tell the wizard which field should be indexed in the new table.
 * Note**- You can also correct the data type as desire. The computer will automatically select text if not change.

7. Select a field as a primary key or let access pick one you. 8. The next step will allow you to name you table. Click Finish when done.


 * Note-** If an error occurs when clicking finish, try to backtrack your step to edit correctly.

Thank You Ruben Ocanto