Excel=FrontEnd and Access=Backend DB

[M P]

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

MP

 

[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

 

[Tom Ogilvy]

Data=>Get External Data

 

[M P]

Do you have web reference that I may use?

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

 

[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.