none
Import data to Access2013 RRS feed

  • Question

  • I am working to gain experience of using Access 2013.

    I export a file of Excel 2007 to Access 2013, It worked smoothly till the end. but, I can not find the newly created ACCESS FILE in my computer, where is it stored?

    Richard


    Richard

    Friday, September 6, 2013 10:03 AM

Answers

  • Hi Richard,

    As far as I know, we can only import an excel file to an existing access database.

    Here are my steps to import an excel file to Access 2013:

    (1) Create a blank Access Database. By default, it will be saved to “C:\Users\[user]\Documents\[filename].accdb”.

    (2) EXTERNAL DATA > Excel


    <THE CONTENT IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, WHETHER EXPRESS OR IMPLIED>
    Thanks
    MSDN Community Support

    Please remember to "Mark as Answer" the responses that resolved your issue. It is a common way to recognize those who have helped you, and makes it easier for other visitors to find the resolution later.

    Tuesday, September 10, 2013 7:27 AM
    Moderator