Creating a new links server to MS ACCESS DB

How do you create a link to MS Access DB in SQL Server 2005. Thanks

The following sp example can get you started.

exec sp_addlinkedserver @.server='AccessDb',
@.srvproduct='Access',
@.provider='Microsoft.Jet.OLEDB.4.0',
@.datasrc='C:nwind.mdb'

|||

Hi, sorry I am new at this. Where do you enter this information?

Disregard the above. I used this query from support, and it worked wonderfully:

sp_addlinkedserver 'Nwind', 'Access', 'Microsoft.Jet.OLEDB.4.0',

'E:\DatabaseLocation\test.mdb'