| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query From Excel to Access
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MS Query From Excel to Access
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 "Filo" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MS Query From Excel to Access
Thank you
"FSt1" wrote: 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 "Filo" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MS Query From Excel to Access
Hi FSt1
Really stupid question: How do I list the dbase as a data source on the server? Much appreicated. Wilhelm "Filo" wrote: Thank you "FSt1" wrote: 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 "Filo" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MS Query From Excel to Access
I think he means you select DataImport External DataNew Database
Query (in Excel 2003) and select your Access database. HTH, JP On Mar 4, 4:56*am, Wilhelm wrote: Hi FSt1 Really stupid question: How do I list the dbase as a data source on the server? Much appreicated. Wilhelm |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MS Query From Excel to Access
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 "JP" wrote: I think he means you select DataImport External DataNew Database Query (in Excel 2003) and select your Access database. HTH, JP On Mar 4, 4:56 am, Wilhelm wrote: Hi FSt1 Really stupid question: How do I list the dbase as a data source on the server? Much appreicated. Wilhelm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
| Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
| Run Access query from Excel, input value to query being value in c | Excel Programming | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| Access query vs. Excel query | Excel Programming | |||
Hybrid Mode
