Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Berkshire, UK
    Posts
    22

    Unanswered: Importing external info into my db

    Hi All,

    First and foremost... great forum.

    Second, isn't this db stuff addictive.

    And the question....

    I have a database with two tables, one for contacts and one for the companies those contacts work for (often more than one contact per company). I would like to import new data into this from one single spreadsheet source (Excel) which contains all of the information I need to for both tables. Is there an easy way to do this? Don't worry about dupes at this stage.

    Cheers all.

    John

  2. #2
    Join Date
    Dec 2004
    Location
    Connecticut
    Posts
    85
    If you just need a one-time import of the spreadsheet data, import it as a new table and then use appropriate queries to add "new" companies and contacts to your tables.

    If the spreadsheet is the only place where updates are available (i.e. someone else or another app can only create excel spreadsheets), create a link to the spreadsheet and automate the queries to parse the data into the appropriate tables.

    If you automate it, you'll have to fiddle with the queries to avoid duplicates.

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You can use SELECT DISTINCT to pull a list of only the companies present in your import. Then use a string comparison to pull the appropriate company id into your employee table.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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