Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

VB Access Table creation from a SQL Pass-Through Query

Discussion in 'Information Technology' started by wnfisba, Jul 28, 2006.

  1. wnfisba

    wnfisba
    Expand Collapse
    Guest

    I've created a SQL Pass-Through Query through VB utilizing user-defined date
    parameters. Is there a way that I can execute this query and create an Access
    Table dynamically based on the result table? I know I've done this before
    utilizing a "Make-Table" Query. Should I create a macro that executes the VB
    creating the SQL Pass-Through Query with the user-provided begin and end date
    and then execute that with another macro step with a Make-Table Query???

    Any help would be GREATLY appreciated.

    Thanks!
     
  2. Loading...


  3. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    Yes.

    --

    Terry Kreft


    "wnfisba" <wnfisba@discussions.microsoft.com> wrote in message
    news:ADE47661-C9E6-44F7-8C49-2027A4E9C123@microsoft.com...
    > I've created a SQL Pass-Through Query through VB utilizing user-defined

    date
    > parameters. Is there a way that I can execute this query and create an

    Access
    > Table dynamically based on the result table? I know I've done this before
    > utilizing a "Make-Table" Query. Should I create a macro that executes the

    VB
    > creating the SQL Pass-Through Query with the user-provided begin and end

    date
    > and then execute that with another macro step with a Make-Table Query???
    >
    > Any help would be GREATLY appreciated.
    >
    > Thanks!
     
  4. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

    you should just use Access Data Projects and then you dont have to deal
    with any of this SPT bullshit.

    -Aaron




    Terry Kreft wrote:
    > Yes.
    >
    > --
    >
    > Terry Kreft
    >
    >
    > "wnfisba" <wnfisba@discussions.microsoft.com> wrote in message
    > news:ADE47661-C9E6-44F7-8C49-2027A4E9C123@microsoft.com...
    > > I've created a SQL Pass-Through Query through VB utilizing user-defined

    > date
    > > parameters. Is there a way that I can execute this query and create an

    > Access
    > > Table dynamically based on the result table? I know I've done this before
    > > utilizing a "Make-Table" Query. Should I create a macro that executes the

    > VB
    > > creating the SQL Pass-Through Query with the user-provided begin and end

    > date
    > > and then execute that with another macro step with a Make-Table Query???
    > >
    > > Any help would be GREATLY appreciated.
    > >
    > > Thanks!
     

Share This Page