Monday, June 4, 2012

Excel 2010 - Microsoft Query to Mosaiq SQL



This is a reminder to use Microsoft Query in Excel 2010 just like the way I used in Excel 2003.  First, the Mosaiq DSN has to be added into ODBC Data Source Administrator.  Then use the "From Microsoft Query" in Data ribbon as shown above.  It will prompt you to choose the data source as shown below. 




After that, everything will be just the same as we used to see in Excel 2003. 


Yabee~

No comments: