No wizards, no code, no fuss: Copy Excel data and paste it into an Access database (2007)
---------------------------------------------------------------------- No wizards, no code, no fuss: Copy Excel data and paste it into an Access database (2007) If you're constantly importing data into Access from Excel, Microsoft Access 2007 has a real treat for you. You can now move data from one application to the other using only the Clipboard! To import Excel data into Access: 1. Open your Excel file and select the data (with the headings) that you want to export. 2. Copy the data to the Clipboard. 3. Open an Access 2007 database and create a new table in the Datasheet view. 4. Right-click on a cell in the upper right portion of the Datasheet and select Paste from the shortcut menu. When you do this, Access adds all the data to the new table. It even initially assigns each column a Data Type that fits with each field's contents. Although Access creates an Auto Number field during the import, you can delete this column if you don't need it. However, all you really need to do is modify the column names and save the new table.
