Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Summerville, South Carolina, USA
    Thanked 0 Times in 0 Posts

    Excel data to different Access tables (Access 2000/XP)

    We have an Exel for that offices use when requesting a file number from the corporate computer. The information on the Excel form eventually winds up in various Access tables mainly because of the relationships set up when designing the application. Is it possible to import this information into the Access table and the right Excel fields go into the right Access table fields without having to retype it in? I'm sure there must be a way, but I sure haven't seen any examples of importing data into multiple tables...single tables, yes. So, can someone point me in the right direction to see if I can incorporate this into the application?


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Excel data to different Access tables (Access 2000/XP)

    You can't import data from Excel directly into different tables, but you can link the Excel table in Access, and create a series of append queries based on the linked Excel table to add the data to various tables.

Posting Permissions

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