Connection between MS Access and SQL Server

[yesu prakash]

Hi, How to access database of MS Access from SQL Server? eg: I have a MS Access database with empoloyees details. From SQL Server database i need to get the employees details from MS Access. Thankyou, YPKI

[Rajesh Anuhya]

hi Right-click on the database in SSMS object explorer, select TASKS --> IMPORT DATA from the window follow the remaining instructions.

Rajesh B --> A Simple Programmer <--

[yesu prakash]

There is no IMPORT DATA in TASK. I am Using 2005 SQL Server. Also i want to connect with ms access to retrive the employees details from a stored procedure when requried.

[Lost User]

Create a linked server[^], and copy the records over into a table in Sql Server.

Bastard Programmer from Hell :suss:

[SilimSayo]

Try this link[^] Go to the section that says Create an Access project.

[RDBurmon]

Use this SELECT TestField1 as t1_from_C_Drive From OpenRowset('Microsoft.Jet.OLEDB.4.0',';Database=C:\temp\Test.mdb;', 'SELECT * from T_Test') as b