Quote Originally Posted by alansidman View Post
Why not use the import feature within Access? Access and Excel talk nicely to each other.
Hi Alansidman
Thanks for answering. I am familiar with the Excel import function into Access this I am using for complete worksheets.
I am using 2 screens(monitors) Access monitor and Excel monitor
I like to drag/drop only a few cells from the Excel worksheet into the Access form.
The problem is: the cells are not on a fixed location in the worksheet. The location differs every time; for example D5:D10 next D15:D19 next D21:D28 aso
With Control+C and Control+V it will be done, but I like a faster way by drag/drop straight into the Access form.

Drag/drop with only one cell will do, but 2 or more cells doesn't work.

In the meantime I found in another forum the same question, which was placed in 2008 by another fellow
Quote
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 ?
unquote
However no solution at all.




Any other idea?
Kind regards
Ron