If you have data in an Excel worksheet, what methods could you use to move the data inExcel to Access? How would you decide between the methods?

What will be an ideal response?

You could cut and paste the Excel data into an existing table, import it to append to an existing table, import it to create a new table, import it as a named range, or you can manually enter the data into Access.
• If there is an existing Access table, you would want to check that the Excel worksheet column headings are exact matches to the field names in the Access table. If the column headings and field names are identical, you would probably choose to import and append to that table. You are unlikely to cut and paste a complete worksheet for fear of pasting into the wrong fields. If the headings are not an exact match, you would need to change the Excel field names to make them match.
• If there is not an existing Access table, you could either design the table in Access and then import and append, or you could import the Excel worksheet to create the table and make changes in Access. If the Excel worksheet is close to the desired Access table, either method would work.
• If there are major differences between the desired Access table and the Excel worksheet, you might need to design the table in Access and manually enter the data. Avoid this if there is a great deal of data.