Connect To SQL Server / Database

K

KevinW

How can I use access to connect to an sql database in Access 2007. This was
easy in access 2000 but is not apparent in Access 2007.

Thanks
 
G

George

How did you do it in Access 2000? LInked Tables I assume?

To link to SQL Server tables via ODBC in Access 2007, select "External Data"
from the ribbon, then in the "Import" chunk select "More". One of the
options there is "ODBC Database".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keeping Access Running Between SQL Server Reboots 3
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Does Microsoft recommend databases or projects to connect to SQL s 1
Access Lock File .LACCDB / Now shows as a notepad file 0
Force "read only" in Connection String??? 2
SQL Server Backend is Read Only 7
Connecting to SQL Server DB in Windows 7 1
Unable to make design changes in .adp connected to SQL server 2008 1

Top