SQL Connection

[Ant]

Hi,
Can any one help with how to crate a SQL Connection.adp? I have liked to
other databases and Excel workbooks in the bast useing File... Get external
data but cant work out how to import or link SQL. ( *.adp file type if
there is more than one way)

Thanks for any help.

 

[Brendan Reynolds]

No data is stored locally in an ADP, it's a front-end application file only.
The data is stored in a SQL Server database. To link or import data from a
SQL Server database, from the 'Files of type' list, choose 'ODBC Databases'.

 

[Norman Yuan]

To Connect to SQL Server with Access ADP, you click menu
"File->Connection...", which brings up "Data Link Properties" dialog box,
where you specify SQL Server name, database name and login information, in
order to get the ADP connected.

If you want to import or link an SQL Server database with Access, you do not
use *.adp, you use *.mdb via ODBC.