How to link tables on SQL Server from MS Access Project?

Question

Requesting examples for link tables on MS SQl from Access Project database (in MS Access Project only have IMPORT does not have LINK under "get external data" tab.

Answer 1

It sounds to me like you are referring to Excel, not Access.
For Office2003 Pro:
In Access, you right click in the tables pane and select Link Tables... In the Files of Type dropdown box scroll down to ODBC Databases. Select your ODBC SQL connection from there.
In Excel, Import External Data, select New Database Query. Your ODBC connection should be accessible from there.