View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kelii Kelii is offline
external usenet poster
 
Posts: 2
Default Can you use ADO from Excel to run an Append Query in Access

.... if so, do you mind providing sample code?

I looked everywhere for this and can only find sample code for DAO.
I'm a big fan of DAO (who says ADO is simpler?) but I'm trying to get
into the 21st century.

This is what I have so far:
'Setup ADO for executing action query
Dim cmd As New ADODB.Command
cmd.ActiveConnection = gsCONNECTION
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "qryRecipCompRevenuesAndDisputes_Step3"

'Execute
cmd.Execute

Needless to say it fails miserably and I'm embarassed to post it.

All help appreciated.

Thanks,

Kelii