Drag and Drop (or cut and paste) records from Access and Excel to my app

Hi everybody

I would like to be able to fill the contents of  a Delphi form from an Acess or Excel "record" preferably via drag and drop.

1. In Access I can do a selection of some rows and then copy it to clipboard and thence to wherever.. the clipboard contents MAY be in some special format, because when I  paste to a text editor the contents include a row with the field names.
 
How can I find out if this is some special format on the clipboard?

2. I would prefer to drag those rows from Access and drop them on my Delphi app. Is there any way of doing this?

3. Excel is not as nice as Access in that it does not give me the field (column) names in a simple copy and paste to text editor (and omits empty fields) , but because there is a "paste special" entry in the context menu, it makes me think that the copy on the clipboard should  contain significantly more info.

If so, how can I find out about this? Where is it likely to be documented .. I guess the more general question is how can I find what any app pastes to the clipboard, and in what format .. some sort of clipboard monitor?  I had a quick look at Tclipboard, butI am not sure if it detects all clipboard formats

4. Again, I would like to drag the selected rows from Excel to my app .. is there a way?

Mutley2003Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DragonSlayerCommented:
You would need to find out more about OLE Drag and Drop then... Here are some links that might be useful to kickstart:

http://www.softandco.com/a/4052/unitoops-ole-drag-and-drop-components.html
http://www.wideman-one.com/gw/tech/Delphi/dragdrop/
0
Lee_NoverCommented:
don't know the format of excell OLE Data (probably has severa different formats, the first being the richest)
but you can use this as a start for handling OLE drag&drop .. clipboard handling can be implemented in the same way
http://leenover.homeip.net/isapi/pas2html.dll/pas2html?File=/delphi/Projects/DragDropStuff/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mutley2003Author Commented:

thanks for the feedback and the code (Lee).  DragonSlayer, fwiw, unitoops is now DropMaster at www.raize.com selling at $99

from experimentation, it appears that neither Excel or Access initiate a drag for a selected row. So I cannot drop what has never been dragged.

This seems very peculiar behaviour on the part of Office.


There is a somewhat useful article on the preferences of various Office applications for different clipboard formats at http://www.codeguru.com/Cpp/W-P/clipboard/article.php/c3015/

0
Lee_NoverCommented:
useful stuff there .. tnx :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.