Administrator: Rave Reviews (Start) 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

Import from Excel External Data can mean importing a spreadsheet or a table. It can also mean linking to an outside source. Here are the steps to import a spreadsheet from Excel.   Try it: Import from Excel Go to External Data->Import->Excel Select Import into new table and walk through the Wizard:   Show Worksheets: MyCalendar First row contains headings: yes Field Options: Do not index any fields. Primary Key: Let Access assign Table Name: tblCalendar   Keep going...;-) External Data-> Import ->Excel