Can a file in excel be transferred to access?

[Guest]

I have a large file that was done in Excel that needs to be somehow converted
to Access. It contains a list of employees that have access to multiple
location as well clearance. Is it possible to add drop down boxes for each
name since they work in more than one building?

 

[Rick Gittins]

You can import it as a one time event by going to File => Import, but if you
need to do this on a ongoing basis you may want to set up code or a macro to
automate it.

The functionality of Excel and the filtering is not the same in Access. You
would need to create a form which would open a query using paramaters that
you have set up on the form or when you go into the data view of a table and
look at the filter by selection or filter by form it may be what you are
looking for.

Rick