"Paul" <Paul@discussions.microsoft.com> wrote in message
news:60E91952-4EF4-4A7C-819F-14CAF4540771@microsoft.com...
> I have a SQL database which I would like to use in Access2003 program.
How
> do I establish a connection for Access to utilize this data?
> Thanks
> Paul

"Mike Epprecht (SQL MVP)" wrote:

> Hi
>
> Crate a new Access Database (or use an existing one).
> In access:
> File>Get External Data> Link Tables
> Select ODBC Databases in the File of Type dropdown
>
> It will ask you for Datasource, Create a Machine DSN.
> That will get you on your way.
>
> There is a lot of help in Access BOL "Linked Tables"
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Paul" <Paul@discussions.microsoft.com> wrote in message
> news:60E91952-4EF4-4A7C-819F-14CAF4540771@microsoft.com...
> > I have a SQL database which I would like to use in Access2003 program.
> How
> > do I establish a connection for Access to utilize this data?
> > Thanks
> > Paul
>
>