Explore BrainMass

Explore BrainMass

    Microsoft Access: Importing Excel Problem

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Please see attached.
    Please help import the data in Excel to the table in Access. There are 6 tables in Access (Contacts, Customer, Orders, Products, SalesRep and Territories) and I also created 6 sheets in Excel for the data for table. But for some reason I can not import the data in to Access.

    (Since I can not attach Access file here, I changed the file extension to Excel "Access.XLS". So please change it Access.mdb when open).

    © BrainMass Inc. brainmass.com March 4, 2021, 5:58 pm ad1c9bdddf
    https://brainmass.com/computer-science/files/microsoft-access-importing-excel-problem-21431

    Attachments

    Solution Summary

    The solution assists with solving the importing problem through Excel.

    $2.19

    ADVERTISEMENT