Auto Fill in data from a microsoft access table to a microsoft excel table

[krt08f]

---

<!-- / icon and title -->

I have a master database table in Microsoft Access 2007. I do not want to copy and past information. I have a formatted schedule done in Microsoft Excel 2007. I need to be able to enter in an employee number that is six digits long in the Excel Schedule and have it automatically fill in the rest of the information (Shift, Role, Phone Number and Office Number) that is associated with that employee in the master database in Microsoft Access. I also need for it to be able to do that if I put in a new employee in my master database. New entries in the master database need to auto fill in the Excel Schedule. I am not good with SQL or anything like that. I tried a query, but it wasn’t working for me. Can anybody provide me the easiest way to do this? I provided example of the two files in a zip folder

<TBODY>
</TBODY>

 

[crazypabs]

hi,

have a look into the use of the SQLRetrieve function in the help files.

Good luck

Matt

 

[krt08f]

There's actually two people other people wo need to use this. They don't want to do that. Is there a way for Excel to connect to the database and just pull the rest of the information with the id without having the results pending?