Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: linking data

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    80
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to link data from a database say MS Access to my sheets in excel. What is the best way to do this?

    I also want that when data is imported only the data that matches a certain criteria is imported.
    I need the data for say sheet 1 to come from two or more access tables or queries. The size of these
    tables and queries can vary therefore you cant really know how many rows of data will be
    imported. But if possible I want it to be imported as one big list from the database even though
    it comes from different tables or queries.

    Can I automate the process of checking everytime I open the sheet, that it checks from the
    source if there has been any changes to the database. If there are changes then it reloads
    the data or if no changes then no action is taken.

    How do I go about this? Any ideas? If it involves using VB or VBA please give a few hints
    cause I am new to it and learning. Thanks.

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello buddy

    I am not saying this will solve your problem,but what I normally do is,-If the file is in access,I export it to excel and vice versa,then I do the tricks neccesary.You can try the same,If it does not work for you I suggest you wait for more suggestions.I will monitor this one closely for I also might learn something new today

    Regards


    Gareth Lombard

    ŎŎ⌐

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    80
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi gareth thanks for the help. I am already doing that but was wondering if there is any other way that would link it.

    Any help appreciated. Thanks.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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