drag and drop data from Excel into Access 2007

  • Thread starter Thread starter EV
  • Start date Start date
E

EV

For years I have exported data from Excel into Access just dragging and
dropping it in the appropriate tables.
I just upgraded to 2007 and can no longer do this and have to import the
data using the "import" function.
Did this functionality disappear in Access 2007 or am I missing something ?

Thanks
 
I move data between Access and Excel almost every day using Access 2007.
I've never had a problem. I'm not sure what you are doing with "drag and
drop", but copy and paste works the same as it always had.

I have found one difference with Office 2007. If you copy data from an
Access table or query, you can no longer paste values
into Excel (so the data is copied without any formatting). Instead, you
have to do a Paste Special | Text.
 
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)....
 
Back
Top