MS Access Importing an Excel Worksheet into a backend Database

Posted on 2012-08-14
Last Modified: 2012-08-19

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.

Question by:TonyMannella
    LVL 77

    Expert Comment

    Items do not appear in the linked table manager until after they have been linked.

    You need to use the External Data option  (Access)  on the ribbon to see it in the front-end .

    Author Comment


    So would I be correct in that I would take the excel spreadsheet,  export into an a "blank" access database and then import that table  into my back end database, then on the Front End use the external data option choosing access and then once in the front end it will be available in the Linked Table Manager?
    LVL 77

    Accepted Solution

    If you just want to add the excel data as a  new table then you can import it directly into the backend database.  There is no need for any intermediate stage.
    Then in the front-end you set up the link.

    Author Closing Comment

    Thanks for the info - Works Well

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now