Access+Participation

Copy and Paste From Excel
Many good lists start in Excel and need to transfer into Access. Here is a simple way to get data into Access quickly. 1. Copy the data from Excel. 2. Create a new table inside Access 3. Click on the Add New Field 4. CRTL V – just like that you get a table inside Access. The new Table Tools contextual ribbon allows you to make the most common schema changes without flipping into design. You should also notice the behavior of copy and paste from Excel to Access has been improved in other areas.