I discovered a cool trick with MSSQL where you can use linked server to join databases across various platforms. Specfically Excel, and Access. Then you can use normal MSSQL query to get to the information.
Very cool.
I discovered a cool trick with MSSQL where you can use linked server to join databases across various platforms. Specfically Excel, and Access. Then you can use normal MSSQL query to get to the information.
Very cool.