Access & SQL

  • Thread starter Thread starter Ravi
  • Start date Start date
R

Ravi

Does how to connect access to sql or link Access tables to
sql server? Not using Access Projects.
 
Ravi said:
Does how to connect access to sql or link Access tables to
sql server? Not using Access Projects.
Click to expand...

File - Get External Data - Link Tables - (Type = ODBC)
 
To link Access tables to SQL Server you use the Stored Procedure
sp_AddLinkedServer. Here is an example from BOL:
USE master
GO
-- To use named parameters:
EXEC sp_addlinkedserver
@server = 'SEATTLE Mktg',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = 'C:\MSOffice\Access\Samples\Northwind.mdb'
GO
-- OR to use no named parameters:
USE master
GO
EXEC sp_addlinkedserver
'SEATTLE Mktg',
'OLE DB Provider for Jet',
'Microsoft.Jet.OLEDB.4.0',
'C:\MSOffice\Access\Samples\Northwind.mdb'
GO
 
Back
Top