Drag and drop table or query to copy between two databases

J

John Faughnan

I'm sure everyone in this newsgroup knows this, but a Google query
didn't turn up a recent notice on it in this newsgroup or anywhere
else.

I was astounded today to learn that I could drag and drop a table or
query from one Access instance to another. That is, I had to mdb files
open, and I was able to do a copy by drag and drop. No import/export.
I've been wasting minutes for years.

I queried Access help files and I didn't find it documented there. I
tried various modifier keys and I couldn't create a link, only a copy.

Does everyone know this?

Access annoys me very often, but this was a nice surprise for a change.
Sorry if this is old hat.

john
(e-mail address removed)

meta: jfaughnan, jgfaughnan, tips, Microsoft Access 2003, copy, user
interface
 
K

Ken Sheridan

John:

It takes a little digging but it is in Help (at least it is in my copy of
Access 2002). The following is the topic with the third item expanded:

Copy a database object

Copy a database object within a Microsoft Access file

Copy the structure of a table or append data to an existing table

Copy a database object to another instance of Access or to another
Microsoft application

You can copy a table, query, or report to another Microsoft application that
is running on your computer.
1. For each program except Microsoft Access and the application that you
want to copy the object to, click the Minimize button in the upper-right
corner of the window.
2. Right-click the Microsoft Windows task bar, and then click Tile Windows
Vertically.
3. Drag the object from the Database window to the other application.

In fact you can do it with both instances maximised by dragging to the other
instance on the task bar and when this instance becomes the front one drag to
its database window.

Ken Sheridan
Stafford, England
 
J

John Faughnan

Thanks Ken, great to know it's there. I am no fan of Microsoft's
products, but I am in awe of their help file technology and
completeness. I think whoever did the original .CHM work was a genius.

john
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top