MS Query From Excel to Access

[Guest]

Hello-
Is it possible to query from Excel an Access database saved on the server
without having the Access application installed on the local PCs?
Thank you.
Filo

 

[Guest]

hi,
yes. just list the access database on the server as a data source. be sure
to resolve any permission issues if needed.

regards
FSt1

 

[Guest]

Thank you

hi,
yes. just list the access database on the server as a data source. be sure
to resolve any permission issues if needed.

regards
FSt1

 

[Wilhelm]

Hi FSt1
Really stupid question: How do I list the dbase as a data source on the
server?
Much appreicated.
Wilhelm

 

[JP]

I think he means you select Data>Import External Data>New Database
Query (in Excel 2003) and select your Access database.


HTH,
JP

 

[Wilhelm]

Thanks, JP
I think, in the meanwhile, I've discovered that the userID also needed full
access to the shared MSA dbase on the server (I'm sure other variations of
security will do the trick, unfortunately don't have enough time to fiddle
them).
Cheers
W