Connect To SQL Server

  • Thread starter Thread starter KevinW
  • Start date Start date
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.
 
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.
 
Back
Top