Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you use ADO from Excel to run an Append Query in Access
On 11/07/2010 03:16, Kelii wrote:
Kelii, Have you looked at http://support.microsoft.com/kb/278973 There is a downloadable file ExcelADO.exe The text contains the following: "7. Click Sample 4. This sample produces the same results as Sample 1, but the technique that is used to transfer the data is slightly different. In Sample 1, records (or rows) are added to the worksheet one at a time. Sample 4 adds the records in bulk by attaching the Excel table to an Access database and running an append query (or INSERT INTO..SELECT FROM) to append records from a table in the Access table to the Excel table. Once the transfer is complete, the Excel table is detached from the Access database and the workbook that results is displayed in Excel. Quit Excel, and return to the Visual Basic application." |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you use ADO from Excel to run an Append Query in Access
Thanks for the link, that's what I needed :D
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running UPDATE and APPEND queries from Access in Excel | Excel Programming | |||
How do I append data from an excel spreadsheet to a access db | Excel Programming | |||
Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
Paste Append from Excel to Access | Excel Programming | |||
use vba in excel to append data in access | Excel Programming |