Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Checking in Excel to update Access (2000)

    Okay - It is Fantasy time and I know it. What I would like to be able to do is to check in an Excel spreadsheet to find the date under column heading MONTH, then look for the FORM (a number) that is in Access and if it is NOT on the Spreadsheet, Change the Outstanding column in Access from True to False.
    So-o-o - Just how far from possible is this dream?
    <img src=/S/exclamation.gif border=0 alt=exclamation width=15 height=15> Wait! Wait! Could I do this- Import current Excel file as - (Dept) current. Then do a query - Oh heck the one that identifies differences. And - hm - where would I go from there? How many questions can I ask in one message?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Checking in Excel to update Access (2000)

    We've got a midweek special - five questions for the price of four.

    I think there are two possibilities:

    1. If the data in Excel is in tabular form, you can create a linked table in Access that retrieves the data from the Excel table. You can then build queries based on the linked table etc.

    2. If it is not possible to create a linked table, you will have to use Automation, i.e. use VBA to start an instance of Excel, and run Excel VBA from Access.

    I recommend investigating the first option before trying the second one, for if it's possible, it is much simpler.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Checking in Excel to update Access (2000)

    Not as much a fantasy as I thought then. I just have to learn how to do this. Okay start with linked tables. I will get back to you on that.

Posting Permissions

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