Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    28

    Post Unanswered: How do I populate empty db table with records from related excel table?

    Hi


    I have a 2 tables: One that is empty (access table called Barriers) and one excel table that has records (also called barriers). They have similar fields.

    Basically, i want the records from the excel table to be in the access table. I am in the process of populating an empty database from various data sources.

    How can i most easily do this? Do the tables need to have matching fields?

    Thanks for your help

    Sue

  2. #2
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    Create an append query. Fields don't have to have the same names. It is important that the data types for the fields are set correctly. i.e. number, text, currency.

    Hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •