Import Excel Data Into MS Access



This is the first in a series of video lessons where I demonstrate how you can share data between Excel and Access. In this lesson I show you how to Import, Append and Link Excel data to Access tables.

You initiate this process from inside Access. There are “Wizards” that guide you through each step in the process.

I invite you to visit my online shopping website – http://shop.thecompanyrocks.com – to view all of my videos and to explore the resources that I offer.

Danny Rocks
The Company Rocks

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

19 thoughts on “Import Excel Data Into MS Access

    Breandán Meallacach

    (September 20, 2015 - 5:58 am)

    Hi. Is there a way to open a linked table in Access when the source file is opened by another user? I read on a website that if NETWORK SERVICE is added to the network folder, it will allow it. However, I haven't had much success so far. I've also tried importing, but it won't let me import an open Excel file. Thanks in advance!

    Rajkumar Verma

    (September 20, 2015 - 5:58 am)

    Helpful clip! Also, gr8 voice, could use it for Hollywood movie promos :)

    ThatBadBitch

    (September 20, 2015 - 5:58 am)

    Thanks Danny boy. I have an assessent today and this is really helpful.

    3aBap4uK

    (September 20, 2015 - 5:58 am)

    Liked & Subscribed: Thank you for your great work. :-)

    ukmwg

    (September 20, 2015 - 5:58 am)

    xpylonracer

    Isaac-Joseph Olanrewaju Oluyemi

    (September 20, 2015 - 5:58 am)

    Whaooooooo, An eye Opener. Great!

    Abhijeet bhardwaj

    (September 20, 2015 - 5:58 am)

    Hi Danny,

    I need your help can you show how to import data from excel and replace same rows in access

    Regards,
    Abhijeet

    Bobby Brush

    (September 20, 2015 - 5:58 am)

    I have some questions for my membership program (which is largely database field driven) and getting it to link directly with Access. any ideas for that?

    melissao94

    (September 20, 2015 - 5:58 am)

    What if you need to populate a database/tables with the data in the spreadsheet? how would you go about that differently?

    Nandu Dhopavkar

    (September 20, 2015 - 5:58 am)

    Great video. Thanks

    Joe Dez

    (September 20, 2015 - 5:58 am)

    Great video. Thank you very much.

    Auriff Yusuf

    (September 20, 2015 - 5:58 am)

    Good video, but how would you update data to the existing Access Table. It seems to append only but not replace data. I have a table with school students and I would like to update exam marks in the existing table where the ID and the students allready exist.

    Danny Rocks

    (September 20, 2015 - 5:58 am)

    Sorry for the delay in responding.

    Without seeing your data, I have no clear answer to offer you.

    Danny Rocks
    The Company Rocks

    Danny Rocks

    (September 20, 2015 - 5:58 am)

    My pleasure. I am glad that you enjoyed my Excel tutorial.

    Danny Rocks
    The Company Rocks

    indianimages

    (September 20, 2015 - 5:58 am)

    Hey you can also use SysTools Access To Excel to import access data into excel sheet

    Waeem m saleem

    (September 20, 2015 - 5:58 am)

    Thankyou soo much Sir

    W-S Operations

    (September 20, 2015 - 5:58 am)

    Can you explain what out-of-range subscript error message means when trying to import? And how to fix?

    Ryan Sittler

    (September 20, 2015 - 5:58 am)

    Danny,
    Fantastic video! I'm attempting to link many excel files from a shared folder (which is added to daily) to access and can't add each individually. Is there a way to add a table/append a defined region from a specific sheet name automatically when the files are added to the shared folder that you're aware of?

Leave a Reply

Your email address will not be published. Required fields are marked *