Results 1 to 3 of 3
  1. #1
    mdewell is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2012
    Posts
    38

    ALready have table from one excel, but need import from another excel

    Hi,



    I have already imported one excel spreadsheet taking a bunch of computers by name, and made a relational database out of it, as several of the fields had the same data in them. I now have a second spreadsheet that mostly matches the computer names from the first database, yet has a different field with a bunch of simiilar entries, and I'd like to "merge" (JOIN) the two spreadsheets' data.

    The first database has a field called OU, a field called Computer and several other fields that don't match up to the second spreadsheet. The second spreadsheet has a field called OU and a field called Computer, and two other fields that need to be linked with the similar data from the first spreadsheet's data that matches by computer name.

    Any help would be appreciated. June7 helped me a lot with setting up forms for the first spreadsheet's database, but now I think I need to setup an import of the data from the second spreadsheet that matches all the data that's in the existing table(s) of OU and Computer, and link seperate tables to the main database based upon the computer name.

    Thanks in advance.

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Were you able to complete this project of yours - or do you still need help with it?

  3. #3
    mdewell is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2012
    Posts
    38
    Well, I guess I got it solved under another thread. But thanks for check up on me with this.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-23-2012, 11:44 AM
  2. import from excel to one table
    By mojtaba79 in forum Import/Export Data
    Replies: 4
    Last Post: 06-22-2011, 05:39 PM
  3. Upload (import) Excel Table Info
    By AKQTS in forum Access
    Replies: 2
    Last Post: 04-21-2011, 02:07 PM
  4. Disabling Excel import to a specific table
    By JoshD in forum Import/Export Data
    Replies: 0
    Last Post: 04-15-2011, 02:26 PM
  5. VBA to open excel, import on close of excel
    By bdaniel in forum Programming
    Replies: 0
    Last Post: 03-20-2010, 02:45 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