How to pull data from another database and be able to modify

[epardo87]

Hello,

I'm new with access, so I don't know how to do almost anything... currently I have this situation:

• I am creating a database that will be managed by different departments
• First, I'm pulling information from an external excel file which is updated by human resources
  
  • None will have access to the pulled data but HR personnel
  • this database will add or delete rows as employees are hired or quit
  • I have no problem so far

Employee #	Employee Name
1001	John Smith
1005	Mike Myers

• I need to create a new table which pulls data from the HR Database
  
  • I need that this table is automatically adds or delete row, the same way the pulled HR database does
  • I also need to add columns to this table so that the supervisors can determine the shift

Employee #	Employee Name	Shift
1001	John Smith	First
1005	Mike Myers	Second

how can I do this?

Regards!

[ranman256]

Link in the table from HR as another table in your db.
then run queries against it.

[epardo87]

Link in the table from HR as another table in your db.
then run queries against it.

thanks_for_answering._I_did_use_a_simple_query_but _it_shows_me_the_data_and_I_couldn't_add_columns_t o_that_results..._is_there_any_other_way_to_do_it_ so_that_i_can_use_the_data_pulled_from_queries_as_ it_was_a_regular_table?