1 of 1 people found this helpful
Go to Data - Your Excel Data Source - Replace Data Source.
Note your Access data source will require the same field names as the Excel and any calculated fields in the Excel data source also used in the workbook will also have to be recreated in the Access data source. When you replace anything missing will quickly become apparent anyway. Take a backup :-)
Thank you very much!