This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
When running slow stored procedures from Access it may be useful to have the application do something else rather than just show the hourglass. In this example a form flashes a message while the stored procedure executes, and then closes itself on…
After looking into a question at EE, a thought came to my mind that I considered would make a good article. "Transform Text copied from Excel Table into Real Table in SQL" as it is totally possible to do. Here's the result.