Creating linked Excel to Access database

[coloradonew]

I need help on a database project for work. We have an excel file with multiple worksheets on it. The primary worksheet contains all the data (The other worksheets are all linked to the first worksheet for data) I need to link all the information to an Access db for easy access and to keep others from editing the content. The information is as follows:


TENANT COLUMN1 - COLUMN 24
tenant1 -- --
tenant2 -- --
tenant3 -- --

 

[dinochristou]

Not entirely sure what you are trying to do, but if you mean you want to link all the sheets to Access, then yes you can.
You would just use the link table option. When the wizard appears there is an option to chose the specifi worksheet you want within an excel file.

You would need to do this for each sheet if required.

Sorry if this is not what you meant.
If it isnt, please try explain with a bit more detail.

Regards
Dino