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

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


    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


  2. #2
    Join Date
    Oct 2001
    Bay Area, CA
    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