Copy Query Results to Clipboard

LadyDi

Registered User.
Local time
Today, 15:54
Joined
Mar 29, 2007
Messages
894
I found the following code to copy the results of a query to the clipboard.

Code:
DoCmd.OpenQuery "DataLoadTemp_qry", acViewNormal, acEdit
DoCmd.SelectObject acQuery, "DataLoadTemp_qry"

DoCmd.RunCommand acCmdSelectAllRecords

RunCommand acCmdCopy
DoCmd.Close acQuery, "DataLoadTemp_qry", acSaveNo

It works great, except that it is also copying the column headings. Is there any way to copy only the results without the headings?

I'm copying this data to the clipboard because I want to be able to paste it in a program called DataLoad which will load this data into one of our company's legacy systems.
 
Does anyone have any ideas on this one? As it stands now, I have to delete the header row once the query results are pasted into the new program. I would really like to eliminate this step if at all possible.
 

Users who are viewing this thread

Back
Top Bottom