I have a roster package in Excel, which will always need to be in Excel. However, some of the functions I have built depend on lists of staff, locations etc.
The obvious thing seems to be to use Access tables, from a main database, read from Excel.
1) Is there an easy way of looping through all the records in an Access Table?
2) If the Access database is designed in two halves (front-end and back-end), would multiple Excel users be able to access the back-end?
Thanks
Chris.
The obvious thing seems to be to use Access tables, from a main database, read from Excel.
1) Is there an easy way of looping through all the records in an Access Table?
2) If the Access database is designed in two halves (front-end and back-end), would multiple Excel users be able to access the back-end?
Thanks
Chris.