Excel=FrontEnd and Access=Backend DB

M

M P

Is this possible? If yes, Any helpful URLs for this? I appreciate your
immediate response.

MP
 
C

CLR

You can access Access through MSQuery in Excel.......
You can set up a Front-end in Excel, import Access data automatically
through MSQuery, and then process the data in Excel.....

Vaya con Dios,
Chuck, CABGx3
 
M

M P

Do you have web reference that I may use?

I want to do the edit, append and delete thru Excel.
 
T

Tom Ogilvy

That isn't supported in Excel using built in capabilities. You would have
to program it with VBA I believe.

You might link to excel from Access and then all yourdata is in Excel and
reproduce in Access, but I am not sure how that would make Access the
backend.
 
Top