Extracting data from SQL Help!!

  • Thread starter Thread starter skc
  • Start date Start date
S

skc

We have two machines on a peer-to-peer:

MachineA: Office 2000

MachineB: SQL2000 Server, with 2 test tables called cust
and inv with 7m and 168m records respectively.

What I want to do on MachineA, is use an ODBC link to
extract data from SQL2000 on machine B.

Can someone give me some links on the web or tell me what
I should do??

Thanks.

skc
 
-----Original Message-----
We have two machines on a peer-to-peer:

MachineA: Office 2000

MachineB: SQL2000 Server, with 2 test tables called cust
and inv with 7m and 168m records respectively.

What I want to do on MachineA, is use an ODBC link to
extract data from SQL2000 on machine B.

Can someone give me some links on the web or tell me what
I should do??

Thanks.

skc
.
If I'm understanding your request, all you have to do is
open up Access on MachineA. Click on File/Get External
Data/Link Tables. You will then be able to browse to your
MachineB (as long as MachineA has the security, etc.).
You can go into your SQL database, then select the table
that you want to Link. That should be all you have to do.
 
There are 2 different ways to connect.
1. Use an .adp (Access Project). This connects directly to SQL Server. (Be
sure to have the latest SP.)
2. To use ODBC -
a. Set up an ODBC DSN on PC A. Input credentials to log on to the SQL
Server.
b. In Access .mdb file use File, Get External Data, Link
c. Change Files of Type to ODBC
d. Select your DSN.
e. When you see the list of tables in SQL Server, be sure to check Save
Password and then select the tables and Link them.
f. Now use the linked tables in queries just as if they were Access
tables.
 
Can ADP work with Oracle??

-----Original Message-----
There are 2 different ways to connect.
1. Use an .adp (Access Project). This connects directly to SQL Server. (Be
sure to have the latest SP.)
2. To use ODBC -
a. Set up an ODBC DSN on PC A. Input credentials to log on to the SQL
Server.
b. In Access .mdb file use File, Get External Data, Link
c. Change Files of Type to ODBC
d. Select your DSN.
e. When you see the list of tables in SQL Server, be sure to check Save
Password and then select the tables and Link them.
f. Now use the linked tables in queries just as if they were Access
tables.

--
Joe Fallon
Access MVP






.
 
Nope.
It is designed by MS as a FrontEnd to a MS product. <g>

You can use linked tables against Oracle.
I do it all the time.
 
Back
Top