Wow, I hadn't heard of dragging and dropping either until I read this post,
so I decided to give it a shot. In Excel, select the data you want to bring
into Access. Hover over the border of the selection until you get the
Drag/Drop icon. Drag the selection to your Access window, and drop it on the
left hand "object window?" to create a new table. It even asks you if the
first row contains the column headers. So, this is a quick way to build a
table in Access 2007 from Excel data, without importing/exporting. This is
convenient for me when I don't want to import the entire spreadsheet ... just
some of the data in the list, but not all.
A couple of pointers I discovered: If you simply select and drag, it Cuts
the data from your Excel sheet. You can easily Ctrl+Z to Undo. OR, if you
hold down the Ctrl key before you select, it'll Copy instead of Cut.
Also, the name of the Access table is the same as your worksheet (tab) name.
Now, if I could just re-discover how to copy and paste from Excel into a new
table in order to create the fields (like I THINK I was able to do in
2003)....