Welcome to SPN

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

Sign Up Now!

Can ADP get data from more than one sql db?

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

Tags:
  1. hommer

    hommer
    Expand Collapse
    Guest

    It seems there is a limitation when I created an adp with existing data. Can
    I selectively get tables from more than one sql databases?

    Thanks!
     
  2. Loading...


  3. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    Have you tried the menu
    File/Get External Data/Link Tables

    to see if that does what you want?

    --

    Terry Kreft


    "hommer" <hommer@discussions.microsoft.com> wrote in message
    news:512B879D-6718-421C-8552-8D655E175225@microsoft.com...
    > It seems there is a limitation when I created an adp with existing data.

    Can
    > I selectively get tables from more than one sql databases?
    >
    > Thanks!
     
  4. hommer

    hommer
    Expand Collapse
    Guest

    Yes, it did. It added a view to my sql database and has it listed under
    Queries in ADP. The data is updatable. I will see how it behaves when I code
    against it.

    Thanks!

    "Terry Kreft" wrote:

    > Have you tried the menu
    > File/Get External Data/Link Tables
    >
    > to see if that does what you want?
    >
    > --
    >
    > Terry Kreft
    >
    >
    > "hommer" <hommer@discussions.microsoft.com> wrote in message
    > news:512B879D-6718-421C-8552-8D655E175225@microsoft.com...
    > > It seems there is a limitation when I created an adp with existing data.

    > Can
    > > I selectively get tables from more than one sql databases?
    > >
    > > Thanks!

    >
    >
    >
     

Share This Page