Results 1 to 3 of 3
  1. #1
    Huddle is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    318

    Linking DB with Excel

    This is what I am trying to do.



    I have a database I use for entering Work Orders. I have been cutting and pasting the table to an excel sheet after I enter the data. This excel sheet is used by others who may enter resolution data that needs to be updated in my database but the only way I can discover it is to search it out.

    What I would like to do is link the DB and Excel sheet so when something is entered in either it is updated in the other.

    The only purpose for the excel sheet is that old dogs don't like new tricks and don't want to use the database. Of course as you know the database is easier to manipulate which is why I am using it.

    The excel workbook has multiple sheets (months). If you can only link one sheet I may be able to convince them they can filter it.

    Is linking what I should be doing or should I continue to cut and paste?

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    I'm not sure if you can do this. As far as I know you can't modify the FE (the db) sources, which are the tables of course.

    what you could do though is write a bit code to export your table and overwrite the old one everytime you need to.

  3. #3
    Huddle is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    318
    Linking the DB Table & Excel sheet will work for what I want to accomplish however I can only do one worksheet. I will just filter the worksheet and they will have to adjust.

    Thanks

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

Similar Threads

  1. Linking Access Table with already imported External Data (Excel)
    By izzarshah in forum Import/Export Data
    Replies: 1
    Last Post: 07-29-2010, 09:40 AM
  2. linking contacts
    By jkorinek in forum Access
    Replies: 1
    Last Post: 06-11-2010, 03:55 PM
  3. VBA to open excel, import on close of excel
    By bdaniel in forum Programming
    Replies: 0
    Last Post: 03-20-2010, 02:45 PM
  4. Linking
    By Tang99 in forum Access
    Replies: 1
    Last Post: 03-03-2010, 08:32 AM
  5. Linking Excel file problems
    By KevinH in forum Import/Export Data
    Replies: 1
    Last Post: 12-20-2009, 09:28 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