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!

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

to see if that does what you want?

--

Terry Kreft


"hommer" <(E-Mail Removed)> wrote in message
news:512B879D-6718-421C-8552-(E-Mail Removed)...
> 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!

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" <(E-Mail Removed)> wrote in message
> news:512B879D-6718-421C-8552-(E-Mail Removed)...
> > 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!
>
>
>