ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   accessing data from Access (https://www.excelbanter.com/excel-discussion-misc-queries/159567-accessing-data-access.html)

DEI[_2_]

accessing data from Access
 
Can someone point me in the right direction. I want to be able to access
data from one table in an Access database. In greater detail, I have a
spreadsheet that has about 4 fields that I need to pull Employee information
into. I would like to be able to select a drop down menu of employees, or
better yet, enters the employee's name as I type their name(index?). When
the name is selected it enters the other data fields like position,
location, etc.

Any help would be greatly appreciated!



Ron de Bruin

accessing data from Access
 
Hi DEI

Maybe this page will help
http://www.rondebruin.nl/accessexcel.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DEI" wrote in message ...
Can someone point me in the right direction. I want to be able to access
data from one table in an Access database. In greater detail, I have a
spreadsheet that has about 4 fields that I need to pull Employee information
into. I would like to be able to select a drop down menu of employees, or
better yet, enters the employee's name as I type their name(index?). When
the name is selected it enters the other data fields like position,
location, etc.

Any help would be greatly appreciated!




All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com