View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Angus Comber Angus Comber is offline
external usenet poster
 
Posts: 1
Default Excel as front end to an Access database - is it possible?

Hello

I want to have Microsoft Excel act as an editing front end to Microsoft
Access via an SQL query. Basically a query - eg

SELECT SubTable.*, MainTable.* FROM MainTable INNER JOIN SubTable ON
MainTable.SiteID = SubTable.CustomerID;

So that a user can for example go in and edit a postcode and then somehow
save any changes made.

Would this be possible?

Any guidance on the procedure would be most appreciated.

Angus Comber