View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default Send SQL to Access from Excel using ADO

I am using Windows XP with Office 2003; ADO 2.7.

In the past, I have always only need to return a recordset from Access so I
know how to do that. But, now I need to send a SQL command to Access using
ADO.

Can someone please post example ADO to do that? I use an ODBC-type
connection string as follows:

ConnectionString = "DRIVER={MICROSOFT ACCESS DRIVER (*.MDB)};DBQ=" &
argFullName & ";USER ID=;PASSWORD=;"

Thanks much in advance.