Creating a database with link

Hello,
I am trying to figure out the best way to design a database that links to
external information like freedb.org and amazon, ect. I have created the
tables of the information I am looking for, but am wondering if I have to
create a table to link to those places to import the information in the
database I am trying to design. I think it is possible I have two seperate
questions in here. So I will try and breakdown to what I am looking for. I
have a database with specific information, I am looking for. I have media
that contains some, but not all of the information readily available to me.
Now what I want to do is take that bits and pieces of that information and
enter it into my current database and have it search other external
databases, to find the rest of the information and input that information
into my current database. Any help I would appreciate.1)How are you connecting to the other databases ?
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Michael R. Mastro II" <MichaelRMastroII@.discussions.microsoft.com> wrote in
message news:3D1BEE16-A914-44D6-864A-7B6289758826@.microsoft.com...
> Hello,
> I am trying to figure out the best way to design a database that links
to
> external information like freedb.org and amazon, ect. I have created the
> tables of the information I am looking for, but am wondering if I have to
> create a table to link to those places to import the information in the
> database I am trying to design. I think it is possible I have two
seperate
> questions in here. So I will try and breakdown to what I am looking for.
I
> have a database with specific information, I am looking for. I have media
> that contains some, but not all of the information readily available to
me.
> Now what I want to do is take that bits and pieces of that information and
> enter it into my current database and have it search other external
> databases, to find the rest of the information and input that information
> into my current database. Any help I would appreciate.|||Well I haven't connected to any other databases as of yet. But my
connections are set up for TCP/IP and Named pipes.
"Jack Vamvas" wrote:
> 1)How are you connecting to the other databases ?
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
> "Michael R. Mastro II" <MichaelRMastroII@.discussions.microsoft.com> wrote in
> message news:3D1BEE16-A914-44D6-864A-7B6289758826@.microsoft.com...
> > Hello,
> >
> > I am trying to figure out the best way to design a database that links
> to
> > external information like freedb.org and amazon, ect. I have created the
> > tables of the information I am looking for, but am wondering if I have to
> > create a table to link to those places to import the information in the
> > database I am trying to design. I think it is possible I have two
> seperate
> > questions in here. So I will try and breakdown to what I am looking for.
> I
> > have a database with specific information, I am looking for. I have media
> > that contains some, but not all of the information readily available to
> me.
> > Now what I want to do is take that bits and pieces of that information and
> > enter it into my current database and have it search other external
> > databases, to find the rest of the information and input that information
> > into my current database. Any help I would appreciate.
>
>