Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    2

    importing excel spreadsheet issues

    I work for a company where I do quality assurance. We get a spreadsheet every week of the curent employees where I work. What I need to do is import this spreadsheet every week and update my tables.
    Access will not allow me to create good relationships between other tables and the linked table. Also, if I import the table it works fine; however, the second time I import into the same table it gives me a non-descript error message.
    Basically, I don't know anything about how to manage the linked data. I also need to make sure that if data is deleted from the spreasheet that it is _not_ deleted from our database. Employees may leave our company but we still need to retain their records in our database. My _main_ concern is: how do I get this linked data to tables that I can actually work with and create relationships with. I'm just a noob with Access so I'm probably missing some crucial but simple piece of information. I'm bascally looking for information on how people generally handle linked spreadsheets.


    ~James

  2. #2
    Join Date
    Oct 2007
    Posts
    10

    Hope this helps

    Hi,

    Do you know which employees are new to the spreadsheet? If so, you could edit the spreadsheet by adding a column for "new employees" before creating a linked table in Access. Then you could create an append query where the criteria is "new employees". This would add records to a table such as your employee history table.

    Regards,
    James C.
    EDI Analyst

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

Similar Threads

  1. Importing Excel into Access with few requirements
    By pickolizac in forum Import/Export Data
    Replies: 1
    Last Post: 02-18-2009, 12:02 AM
  2. Importing from Excel
    By joer in forum Forms
    Replies: 0
    Last Post: 03-14-2007, 02:01 PM
  3. Importing Excel Sheet into Access dbase
    By tonystowe in forum Import/Export Data
    Replies: 0
    Last Post: 12-08-2006, 11:35 AM
  4. Type error when importing Excel spreadsheet
    By jlmnjem in forum Database Design
    Replies: 2
    Last Post: 08-27-2006, 07:26 PM
  5. Problems with Import Spreadsheet Wizard
    By Conan Kelly in forum Import/Export Data
    Replies: 1
    Last Post: 11-29-2005, 09:39 AM

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