Linking Access to SQL Server
Hi ive got alot of linking tables in Ms Access and I want to link in onto Sql Server 2005.how to i do the liking part
Software/Hardware used:
Software/Hardware used:
ASKED:
May 25, 2010 6:52 AM
UPDATED:
November 9, 2010 11:19 AM
Answer Wiki:
You can do the following :
1. Open EM.
2. Goto the Server to which you want to add it as linked server.
3. Then goto security > Linked Servers section from console tree.
4. Right click on the Client area. Then New Linked Server.
5. Give a name and Specify Microsoft Jet 4.0 as Provider string.
6. Provide the location of the MDB file.
7. Click OK.
Now MS Access table is linked with SQL Server !
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
