Link access database with sql server and run sql statment on sql-server
exec sp_addlinkedserver @server='AccessDb1',
@srvproduct='Access',
@provider='Microsoft.Jet.OLEDB.4.0',
@datasrc='C:\data\Categories_Products_Link.mdb'
exec sp_addlinkedsrvlogin @rmtsrvname='AccessDb',
@useself='false',
@rmtuser='Admin',
@rmtpassword=''
This is my technical area for troubleshooting and learning new programming skills and much more. Here, you will find answers on a wide range of technologies such as AI, Machine Learning, OpenAI, Databricks, ASP.NET, C#, Python, Microsoft Access, MySQL, Amazon Web Services, SQL Server, PL/SQL, JD Edwards, SAS, Salesforce, APIs, MVC, and many others. Please feel free to visit and join the discussion!
Showing posts with label Link Access Database with SQL-Server 2005. Show all posts
Showing posts with label Link Access Database with SQL-Server 2005. Show all posts
Saturday, September 6, 2008
Subscribe to:
Posts (Atom)