Welcome to SPN

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

Sign Up Now!

SQL Pass-Through Query output to Access Table

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

  1. wnfisba

    wnfisba
    Expand Collapse
    Guest

    I have a SQL Pass-Through Query that I have built within an Access Database
    application. I want to be able to run this SQL Pass-Through Query and then
    output the result table into an Access Table. Right now I have a macro that
    "OutputTo" the SQL Query into an Excel spreadsheet. Can I instead "OutputTo"
    this into an Access table?? I do not see the options within the drag-downs to
    do this??

    Any help would be greatly appreciated.

    Thanks!
     
  2. Loading...

    Similar Threads Forum Date
    Microsoft Brings 64-Bit Perks in SQL Server 2000 Service Pack (Ziff Davis) Interfaith Dialogues May 7, 2005

  3. David

    David
    Expand Collapse
    Guest

    Use the query to create a new "Make Table" query.

    hth
    David

    "wnfisba" <wnfisba@discussions.microsoft.com> wrote in message
    news:E297D5DA-08B0-4C0D-8C3E-C8678B1699B8@microsoft.com...
    >I have a SQL Pass-Through Query that I have built within an Access Database
    > application. I want to be able to run this SQL Pass-Through Query and then
    > output the result table into an Access Table. Right now I have a macro
    > that
    > "OutputTo" the SQL Query into an Excel spreadsheet. Can I instead
    > "OutputTo"
    > this into an Access table?? I do not see the options within the drag-downs
    > to
    > do this??
    >
    > Any help would be greatly appreciated.
    >
    > Thanks!
     
  4. wnfisba

    wnfisba
    Expand Collapse
    Guest

    Okkkkkkk...How do I do that???

    "David" wrote:

    > Use the query to create a new "Make Table" query.
    >
    > hth
    > David
    >
    > "wnfisba" <wnfisba@discussions.microsoft.com> wrote in message
    > news:E297D5DA-08B0-4C0D-8C3E-C8678B1699B8@microsoft.com...
    > >I have a SQL Pass-Through Query that I have built within an Access Database
    > > application. I want to be able to run this SQL Pass-Through Query and then
    > > output the result table into an Access Table. Right now I have a macro
    > > that
    > > "OutputTo" the SQL Query into an Excel spreadsheet. Can I instead
    > > "OutputTo"
    > > this into an Access table?? I do not see the options within the drag-downs
    > > to
    > > do this??
    > >
    > > Any help would be greatly appreciated.
    > >
    > > Thanks!

    >
    >
    >
     
  5. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Follow this stages

    1. Create a new query
    2. Select the PassThrough query as the "Table"
    3. Select the field you want in the new table
    4. Change the query to Create new table query (In the menu bar select Query
    > Create Table Query)

    5. Run the query.

    --
    Good Luck
    BS"D


    "wnfisba" wrote:

    > Okkkkkkk...How do I do that???
    >
    > "David" wrote:
    >
    > > Use the query to create a new "Make Table" query.
    > >
    > > hth
    > > David
    > >
    > > "wnfisba" <wnfisba@discussions.microsoft.com> wrote in message
    > > news:E297D5DA-08B0-4C0D-8C3E-C8678B1699B8@microsoft.com...
    > > >I have a SQL Pass-Through Query that I have built within an Access Database
    > > > application. I want to be able to run this SQL Pass-Through Query and then
    > > > output the result table into an Access Table. Right now I have a macro
    > > > that
    > > > "OutputTo" the SQL Query into an Excel spreadsheet. Can I instead
    > > > "OutputTo"
    > > > this into an Access table?? I do not see the options within the drag-downs
    > > > to
    > > > do this??
    > > >
    > > > Any help would be greatly appreciated.
    > > >
    > > > Thanks!

    > >
    > >
    > >
     
  6. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

    if you used Access Data Projects; this would be a LOT easier.

    you wouldn't have to read the data twice for starters.

    -Aaron


    Ofer Cohen wrote:
    > Follow this stages
    >
    > 1. Create a new query
    > 2. Select the PassThrough query as the "Table"
    > 3. Select the field you want in the new table
    > 4. Change the query to Create new table query (In the menu bar select Query
    > > Create Table Query)

    > 5. Run the query.
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "wnfisba" wrote:
    >
    > > Okkkkkkk...How do I do that???
    > >
    > > "David" wrote:
    > >
    > > > Use the query to create a new "Make Table" query.
    > > >
    > > > hth
    > > > David
    > > >
    > > > "wnfisba" <wnfisba@discussions.microsoft.com> wrote in message
    > > > news:E297D5DA-08B0-4C0D-8C3E-C8678B1699B8@microsoft.com...
    > > > >I have a SQL Pass-Through Query that I have built within an Access Database
    > > > > application. I want to be able to run this SQL Pass-Through Query and then
    > > > > output the result table into an Access Table. Right now I have a macro
    > > > > that
    > > > > "OutputTo" the SQL Query into an Excel spreadsheet. Can I instead
    > > > > "OutputTo"
    > > > > this into an Access table?? I do not see the options within the drag-downs
    > > > > to
    > > > > do this??
    > > > >
    > > > > Any help would be greatly appreciated.
    > > > >
    > > > > Thanks!
    > > >
    > > >
    > > >
     

Share This Page