Results 1 to 3 of 3
  1. #1
    aisling21 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    May 2015
    Posts
    1

    Question Importing excel into access data model

    Hi, Quick question.



    When you have created a data model within Access and it has relationships included how do you import a excel spreadsheet into this. Does the spreadsheet have to be the exact same as the data model to be imported correctly?

    Thanks

  2. #2
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    Yes or no.

    Yes, if the spreadsheet is exact the same as the data model and it will be imported correctly and quickly.

    No, if the spreadsheet is not the same as the data model and you will have to import the data to temp table and put them back in the base (data model) table.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,767
    aisling,

    Not sure exactly what you are asking, but it may just be terminology.
    A data model is really a picture or plan or blueprint of a database.
    A physical database is made up of tables, fields and keys (Primary and Foreign).
    You import data into tables.

    The analogy is the data model is much like the blueprint of a building.
    Where as the the database is the real, physical building with rooms, floors, roof, doors etc.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Importing data into Access database from Excel textboxes
    By Sambora in forum Import/Export Data
    Replies: 3
    Last Post: 05-06-2013, 02:27 PM
  2. Importing Excel Data Tables into Access
    By Itch in forum Programming
    Replies: 5
    Last Post: 09-08-2012, 11:27 AM
  3. Importing Data from Excel to Access
    By dkatorza in forum Import/Export Data
    Replies: 3
    Last Post: 11-05-2011, 09:17 AM
  4. Replies: 2
    Last Post: 04-22-2010, 10:40 AM
  5. iMPORTING DATA FROM EXCEL TO ACCESS
    By Rameez in forum Import/Export Data
    Replies: 7
    Last Post: 06-16-2009, 12:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums