Super Basic SQL LINKING question...

[kev100 via AccessMonster.com]

In ACCESS 2.0, I simply need to create a link to an SQL table.

I have access to the SQL tables and can open th SQL manager and browse them.


I've done lots of linking to dBase tables and Visual Foxpro tables via the
ODBC route...but cannot figure out the SQL link process just by "clicking
around."

I've searched everywhere I know. While there are lots of posts asking
questions about SQL linking issues after the link is in place....I've not
been able to find posts about the initial, basic, generic link process itself.


Is there basic step by step instructions for linking to a particular SQL
table available?

Something like...

File / Get External Data / Link Tables / etc...

Sorry to ask just a basic question...but I'm stuck

Thanks

 

[Rick Brandt]

In ACCESS 2.0, I simply need to create a link to an SQL table.

I have access to the SQL tables and can open th SQL manager and browse them.


I've done lots of linking to dBase tables and Visual Foxpro tables via the
ODBC route...but cannot figure out the SQL link process just by "clicking
around."

I've searched everywhere I know. While there are lots of posts asking
questions about SQL linking issues after the link is in place....I've not
been able to find posts about the initial, basic, generic link process itself.


Is there basic step by step instructions for linking to a particular SQL
table available?

Something like...

File / Get External Data / Link Tables / etc...

Sorry to ask just a basic question...but I'm stuck

Thanks

Same as with the ODBC source links you have already done. Of course unless you
want to create the links via code you will need to first create an ODBC DSN that
points to the SQL Server database that you want to link to. Then you...

File
Get External Data
Link Tables
Type = ODBC
Choose your DSN

....and from there you should get a list of the tables available on your SQL
Server.

 

[kev100 via AccessMonster.com]

Thanks very much...

After creating the ODBC DSN it was a snap.

For anyone else referencing this link.....when you create the ODBC DSN, need
to know the location, login, and password of the SQL server that contains the
table you're needing to link to.

But....you gotta make that first. Then go through the regular process of an
ODBC link or import.

Thanks again