calendar

Can I Convert An Excel Doc To A Calendat

How to Convert Excel Documents to Microsoft Access 1.

Launch Access 2010 on your computer.

How to Create a Calendar in Microsoft Excel (with Pictures)
How to Create a Calendar in Microsoft Excel (with Pictures)

2.

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

How to import Excel into Google Calendar by Chris Menard
How to import Excel into Google Calendar by Chris Menard

3.

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

How to Create a Calendar in Excel  Taskade
How to Create a Calendar in Excel Taskade

4.

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

Outlook: Import a schedule from Excel into Outlook Calendar
Outlook: Import a schedule from Excel into Outlook Calendar

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.