Connect To SQL Server

K

KevinW

How can I connect to my SQL Server using Access 2007? I don't want to do
anything more than veiw a table. I know how to do this in Access 2000, but
it is not obvious in 2007.
 
B

bcap

Since you've been doing this in A2000 I assume you already have a DSN
created.

In A2007, click "External Data" in the ribbon.

In the "Import" group, click "More".

Click "ODBC Database"

Choose "Link...etc", then "OK"

From here on in it should all look familiar to you.
 

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

troubles with dns-less connection to sql 0
Snowflake to SSIS 0
connecting Access 2007 to SQL Server 2005 Express 1
Access 2007 can't connect to SQL Server 1
Access 2007 Application - Remote Access to SQL-Server in another c 1
Connect To SQL Server / Database 1
how to connect the access to the sql 4
UPSIZING 4

Top