Results 1 to 5 of 5

Thread: How can I control a SQL query with VB?

  1. May 15th, 2006, 04:30 PM #1
    dfarland
    dfarland is offline

    Thread Starter
    Member
    Join Date
    May 2006
    Posts
    34

    Question How can I control a SQL query with VB?

    I would like to query a SQL db with VB that allows me to filter the data being returned. The DB is fairly large and could fill the number of rows in a excel workbook. So, I would like to change the filter with the code. Any help to get me started would be great
    Reply With Quote Reply With Quote
  2. May 15th, 2006, 04:43 PM #2
    manavo11
    manavo11 is offline
    Super Moderator manavo11's Avatar
    Join Date
    Nov 2002
    Location
    Around the corner from si_the_geek
    Posts
    7,171

    Re: How can I control a SQL query with VB?

    Welcome to VBForums dfarland

    What code do you have so far? How are you executing the query?


    Has someone helped you? Then you can Rate their helpful post.
    Reply With Quote Reply With Quote
  3. May 15th, 2006, 04:46 PM #3
    dfarland
    dfarland is offline

    Thread Starter
    Member
    Join Date
    May 2006
    Posts
    34

    Re: How can I control a SQL query with VB?

    Haven't started it. The query will be executed with vb code, I hope. I have the query in the workbook and can refresh it. But I would like to filter the return by range of dates.
    Reply With Quote Reply With Quote
  4. May 15th, 2006, 04:50 PM #4
    manavo11
    manavo11 is offline
    Super Moderator manavo11's Avatar
    Join Date
    Nov 2002
    Location
    Around the corner from si_the_geek
    Posts
    7,171

    Re: How can I control a SQL query with VB?

    You could do that in the SQL query, just change the Where clauses...


    Has someone helped you? Then you can Rate their helpful post.
    Reply With Quote Reply With Quote
  6. May 15th, 2006, 06:36 PM #5
    dfarland
    dfarland is offline

    Thread Starter
    Member
    Join Date
    May 2006
    Posts
    34

    Re: How can I control a SQL query with VB?

    Yes, I know how to do that, but can I run that from vb?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width