+ Reply to Thread
Results 1 to 6 of 6

Need macros to extract data from database/compare/update database - Excel 2007

  1. #1
    Registered User
    Join Date
    10-15-2014
    Location
    Bangalore
    MS-Off Ver
    2007
    Posts
    3

    Need macros to extract data from database/compare/update database - Excel 2007

    Hi Guys,

    Here's my requirement. Need a excel Macros to do this for me.

    1. I need to extract data from 3 different tables on a database into an excel sheet
    2. Compare these 3 lists and come up with a unique list (Lets call it ListA)
    3. Now i need to compare "ListA" with "ListB" (extracted from another source and i have that handy)

    NOTE:
    * ListB is the master list. I would basically need to remove / add entries based on the ListA content.
    * Entries are mostly email id's

    I hope, i have explained my requirement well. Please let me know if you have any questions.


    Cheeers,
    Saroby

  2. #2
    Forum Contributor
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    227

    Re: Need macros to extract data from database/compare/update database - Excel 2007

    Quote Originally Posted by saroby View Post
    Hi Guys,

    Here's my requirement. Need a excel Macros to do this for me.

    1. I need to extract data from 3 different tables on a database into an excel sheet
    2. Compare these 3 lists and come up with a unique list (Lets call it ListA)
    3. Now i need to compare "ListA" with "ListB" (extracted from another source and i have that handy)

    NOTE:
    * ListB is the master list. I would basically need to remove / add entries based on the ListA content.
    * Entries are mostly email id's

    I hope, i have explained my requirement well. Please let me know if you have any questions.


    Cheeers,
    Saroby
    There are excellent videos on this on youtube:

    https://www.youtube.com/playlist?lis...3akx_gFMnpxTN5

    watch parts 30-32--ADO(activex data objects)

    you'll become a pro after u watch those videos...
    If I've been of help, plz add reputation.

  3. #3
    Registered User
    Join Date
    10-15-2014
    Location
    Bangalore
    MS-Off Ver
    2007
    Posts
    3

    Re: Need macros to extract data from database/compare/update database - Excel 2007

    Thanks sakmsb. Will give it a go :-)

    - Saroby

  4. #4
    Forum Contributor
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    227

    Re: Need macros to extract data from database/compare/update database - Excel 2007

    Quote Originally Posted by saroby View Post
    Thanks sakmsb. Will give it a go :-)

    - Saroby
    Try coding it yourself, if you hit roadblocks, paste your code here, someone will help you out.

    I had the same requirement a few months ago and I had learnt the same from these videos and trust me I'm the best in my Team now related to retrieving, editing, deleting and updating data from macros to DBs.

  5. #5
    Registered User
    Join Date
    10-15-2014
    Location
    Bangalore
    MS-Off Ver
    2007
    Posts
    3

    Re: Need macros to extract data from database/compare/update database - Excel 2007

    Sure will do. Any idea on how to compare three columns of data to extract unique entries.

  6. #6
    Forum Contributor
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    227

    Re: Need macros to extract data from database/compare/update database - Excel 2007

    Quote Originally Posted by saroby View Post
    Sure will do. Any idea on how to compare three columns of data to extract unique entries.
    To be able to do that, it requires an array formula or UDF, I'm not that good with these. Although, I think I know an alternative to achieve that.

    Let's wait for someone else more experienced to follow up on this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 07-10-2014, 01:05 AM
  2. [SOLVED] Check Customer Database, if not found, update database.
    By pipoliveira in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2013, 05:11 AM
  3. Match data between CSV and database and update column in database table
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-05-2012, 05:59 PM
  4. Replies: 5
    Last Post: 06-11-2006, 04:45 PM
  5. Extract Data from an Access Database in to Excel
    By John in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-02-2006, 08:20 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1