Importing Excel to Access auto populating data

15 pts.
Tags:
Microsoft Access
Microsoft Excel
I have imported an Excel spreadsheet into Access (2016) and am trying to figure out how to populate data. For example, I imported a spreadsheet containing employee name, ID, Department, Supervisor. If I select the employee name, I want my form to automatically populate with the rest of the data. This way, I won't have to physically enter the data.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    How did you do the import? What columns are in your Excel spreadsheet and your Access table? You most likely will want to write a script to update your data. More info is needed and any script code you have written will help so we know the columns involved.
    72,775 pointsBadges:
    report
  • motogirl
    Thanks for replying. I imported an Excel file through the Access import feature. Columns include: employee name, employee ID, employee title, department, supervisor. I have not written any script. I haven't built a database in many years and have to refresh myself on it.
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: