I have a split database. What I am trying to do is import an Excel Worksheet into the database as a new table. I have tried to import into the Backend and then use Linked Table Manager to link it but it does not appear in the Linked Table Manager window on the Front End. I also tried (all in a developement environment) to create in the front end and try to link the back end whic of course was not successful.
Is there a way to import an excel worksheet as a table in a split database and have it appear available for linking in the Linked Table Manager Window.
Perhaps I'm doing something wrong in the import and thought there may be some suggestions that I could pursue.