Can I Convert An Excel Doc To A Calendat

How to Convert Excel Documents to Microsoft Access 1.

Launch Access 2010 on your computer.

2.

Click “File” at the top of the Access window and select “Open.”

3.

Select your database using the resulting file browser and click “Open” to open it in Access.

4.

Click the “External Data” tab at the top of the Access window.

5.

Click “Excel” to import the Excel document into your database. The Get External Data – Excel Spreadsheet window pops up.

6.

Click the “Browse” button at the top of the window and use the resulting file browser to select the Excel document.

7.

Click the “Import the source data into a new table in the current database” radio button to create a new table using the data imported from the Excel document. You can also click the “Append a copy of the records to the table” radio button and select a table if you want to insert the Excel data into an existing table.

8.

Click “OK” and the Import Spreadsheet Wizard window pops up.

9.

Select an Excel worksheet to convert to Microsoft Access and click “Next.”

10.

Place a check mark in front of the First Row Contains Column Headings option if the first row of your Excel document contains column headings. Click “Next.”

11.

Select each field and type a name for it in the Field Name text box and select a data type in the Data Type drop-down box. Click “Next.”

12.

Click “Next” to allow Microsoft Access to add a primary key, which is a unique table identifier, to your table.

13.

Click “Finish” to import the data from the Excel document.

14.

Click “Close” to close the wizard.