OK , I was just looking into linked servers on MSSQL. I don't have the proper credentials to do it via the MySQL side!
I believe its the equivalent to federal tables.
Pete
As with most major companies you end up with multiple applications on different databases, which is my case. I was hoping to be able to port the report application over from Access VBA
where I linked the databases. Made it easy to write queries across multiple database types. What I've decided...
I need to create a new dataset from 3 tables and 2 SQL sources 1 MSSQL and the other MySQL.
file 1 contains 30 fields with the index on a network number say 'NetworkID'. (3000 records) file 2 contains 8 fields with the index also on a Network number say 'NWK_ID'. (1,900,000 records) file 3...
I access a web page via code and try to export and download an excel file. But at the usual 'Open Save Cancel' window I can't get the save button to fire!
I found a few similar posts here but the solutions found don't work!
Here is what I have !
Code:
Sub ClosePopup(ByVal WindowHandle As...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.