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

Does Microsoft recommend databases or projects to connect to SQL s 1
SQL Server Backend is Read Only 7
SQL Server 5.0 Express 1
How do you connect Word 2003 to Access 2007 accdb database??? 3
SQL Server verses Sharepoint 12
32 bit access application and 64 bit SQL 2008 2
SQL Database - How to Link to? Other Questions? Help? 2
Access 2007 Project Can't connect to SQL Server 2005 on my machine 2

Top