How to transfer a data from a table to another table?

[topz06]

Hello and good day! I am new in using MS Access. We have this thesis that checks the attendance of the professors and then sends the ID number of the professor to MS Access. I am using smsenabler as the software to encode the ID numbers to the database.

The problem is that, I want to transfer the ID numbers to specific table for the professors name. I don't know how to do it. And I can't make the ID numbers as primary keys because it duplicates every time the professor scans his/her ID. any help would be greatly appreciated. Thanks!

 

[Drunkenneo]

The purpose of doing so is bit unclear, could you please explain elaborately.

Do you have table structre set up already? and so which table you want to send the details?

 

[topz06]

Hello! Good day!

There is already a table set up. The said table is named SMS_IN. The columns on the table are as follows:

sms_text
senders_number
sms_dt

This table is used in receiving messages from a circuit. The said circuit is an attendance checker with RFID and GSM module. Once the professor scans his/her ID, the GSM module will send the ID number of the professor to the database. Since there are many professor, I want to create individual tables for them. By the way, each professor has a unique ID number. In the individual table, the time the message was received on the SMS_IN table should also be displayed. I don't know how to do that. Thank you for your response!