View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
 
Posts: 595
Default Excel as a front end to an Access database

On Thu, 20 Mar 2008 10:09:25 -0400, "BillE" wrote:


The VBA code I have found should work fine, but I don't want to overlook any
better solutions which I haven't stumbled over in google.


Executing SQL statements in a ADO Connection object is the way I do it. So
if that's what you read, then I don't think there's anything new that you've
missed. However, using Access as the front end saves a lot of coding.
--
Dick