accessing SQL via access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello all,

i am a newcommer to the world of SQL and building databases. i have been
working with microsoft products for quite a while and am an MCSE. i need help
with integrating and accessing data from an SQL 2000 server. how do you use
access to create and access data from an SQL server. PLEASE HELP!!!

Ross
 
Ross

Open an Access database (new).

Select File | Get External Data | Link.

The type of data you want to link to is ODBC (probably at the bottom of the
drop-down list).

For Access to access data stored in SQL Server (or VisualFoxPro, or ...),
you have to build an ODBC "helper" file, AKA a Data Source Name (DSN). This
DSN tells Access how to reach (and handle) the data.

You will, of course, need appropriate permissions on the SQL Server side.
 
You must log in or register to reply here.

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

Similarities / differences b/w Access and SQL Server Express 7
SQL Server Backend is Read Only 7
Access and SQLServer Express 2005 3
Insert Into a SQL table via Access 2007 8
Access and SQL Server 7
Access stripping decimal places in query 1
MS Access vs Informix 4GL 3
Good morning 5

Back
Top