Re: takes long time to pull in from table linked to Excel
the problem with linking to excel is that the connection needs to be made which is almost certainly what takes the time. But there are other considerations such as where the file is (on a network? what is network performance like?). How many rows? - excel doesn't have indexes, so sorting finding etc will take longer.
For porting in data, excel is fine (tho' better to use .csv) but as a record/rowsource for general forms, not so good.
I would have a routine to refresh your access table. This can be done with a macro in excel if you wanted to manage the whole thing in one place.
Alternatively, why not use the data connection function to have a linked table to SQL Server instead - although whether that is worthwhile will depend on sql server/network performance
A little thanks goes a long way. If you have found this post useful, please tick the thanks button