Link to home
Create AccountLog in
Avatar of Fritz Paul
Fritz PaulFlag for South Africa

asked on

Use Excel to interface with MS Access query or table

I want to apply Excel as interface for an MS Access database. The user will only have to enter and updata one field in a query (or a table), but needs to see the other fields also. How can I accomplish this?
The reason to do this is that the only database interaction for this user is only this one field in one query. The user is used to simple Excel use and we do not want to expose him to a "new" computer application.
ASKER CERTIFIED SOLUTION
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Fritz Paul

ASKER

I love your reply. I can see that this solution should be exactly what I require. However it seems a bit more complicated than meets the eye. I linked to two databases (.mdb (2003) and .accdb (2010) and the third .mdb (2003) could not link, because it has permissions. All three occasions I was offered different wizards. The one with the permissions, was the only one that offered read/write option, but could not find the workgroup information file.
I think a VBA linking process will work best. Do you perhaps have linking VBA code?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks to you both. Crystal opened my eyes to the possibility to link to Access from Excel side. I always exported from Access to Excel.
Thanks for Jeffrey as you confirmed that what I want to do is not possible.
I do still believe that there must be a VBA way. For instance use the linking from Excel and then have an update button to go and save entered data into the access table. I will ask a question.
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

you're welcome, Fritz ~ happy to help