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


"M P" <[email protected]> wrote in message
news:[email protected]...
> Is this possible? If yes, Any helpful URLs for this? I appreciate your
> immediate response.
>
> MP
>
>

[Tom Ogilvy]

Data=>Get External Data

--
Regards,
Tom Ogilvy


"M P" <[email protected]> wrote in message
news:[email protected]...
> Is this possible? If yes, Any helpful URLs for this? I appreciate your
> immediate response.
>
> MP
>
>

[M P]

Do you have web reference that I may use?

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

"CLR" <[email protected]> wrote in message
news:[email protected]...
> 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 P" <[email protected]> wrote in message
> news:[email protected]...
>> Is this possible? If yes, Any helpful URLs for this? I appreciate your
>> immediate response.
>>
>> MP
>>
>>
>
>

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

--
Regards,
Tom Ogilvy

"M P" <[email protected]> wrote in message
news:[email protected]...
> Do you have web reference that I may use?
>
> I want to do the edit, append and delete thru Excel.
>
> "CLR" <[email protected]> wrote in message
> news:[email protected]...
> > 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 P" <[email protected]> wrote in message
> > news:[email protected]...
> >> Is this possible? If yes, Any helpful URLs for this? I appreciate your
> >> immediate response.
> >>
> >> MP
> >>
> >>
> >
> >
>
>

[enijhuis]

To add to this discussion:
I've created an add-in just for this purpose:
If you want to make use of Excel as a front end for back ends like MS Access (or SQL Server) you may want to check it out:
Connexa add-ins for Excel