importing from SQL Server 2008 Express

G

gator

I am trying to import or copy a table in SQL Server 2008 Express into Access
2003. I am clicking on Import, "Files of Type" - ODBC, DSN Name (New...),
SQL Server. I then browse to the database name in Program Files\Microsoft
SQL Server\MSSQL.1\MSSQL\Data\filename.mdf. I then finish out the wizard and
I get the error ....

Connection failed:
SQLState:'01000'
SQL Server Error:53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).
Connection failed:
SQLState:'08001'
SQL Server Error:17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.

Is there an easier way to just copy a SQL Server table into Access. Or am
I just missing something in the steps I am trying above?
 

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

TransferSpreadsheet method question 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Cannot link to SQL server 17
ODBC Failure, error 18456 1
Able to import but not link tables 2
PWA not functioning 1
SQL Error when connection to Project 2003 DB 0
DSN-less ODBC connection error 1

Top