Access & SQL

R

Ravi

Does how to connect access to sql or link Access tables to
sql server? Not using Access Projects.
 
R

Rick Brandt

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)
 
D

Duane Hookom

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
 

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

Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Access stripping decimal places in query 1
Access 2003 and SQL 4
Difference in size of actual access database and its backup 0
Good morning 5
Migration to SQL Server 3
Linking Tables from SQL Server 1
Re-Seed in SQL Server 8

Top