Introduction This documents explains in details how to retrieve data from XSTUDIO , get it in EXCEL so that it can – be used for different purpose special presentation of the traceability matrix, new charting not … already available in XSTUDIO Prequisite: you need to have access to MS Excel 2007 at the minimum, have read access to all the tables in XStudio Know the user/password for that access Be able to install an ODBC driver on your PC Here we have used Windows 10 Office 2013 MySQL ODBC driver 64 bits, 5.3.1 A – install ODBC driver and enable a connection to be used by MS Excel “start” Open the ODBC Data Source manager (from Windows button) ‘drivers’ Check that the MySQL driver is available, clicking on the tab. ‘user ‘add’ Then get into the DSN’ tab and a new connection. Note: Here we choose to make the connection only available for the current user. If you wish to make this connection available to the PC and all users, you could then choose to create the connection in the system tab.
Introduction This documents explains in details how to retrieve data from XSTUDIO , get it in EXCEL so that it can be used for different purpose – special presentation of the traceability matrix, new charting not already available in XSTUDIO … Prequisite: you need to have access to MS Excel 2007 at the minimum, have read access to all the tables in XStudio Know the user/password for that access Be able to install an ODBC driver on your PC Here we have used Windows 10 Office 2013 MySQL ODBC driver 64 bits, 5.3.1 A – install ODBC driver and enable a connection to be used by MS Excel Open the ODBC Data Source manager (from Windows “start” button) Check that the MySQL driver is available, clicking on the ‘drivers’ tab. Then get into the ‘user DSN’ tab and ‘add’ a new connection. Note: Here we choose to make the connection only available for the current user. If you wish to make this connection available to the PC and all users, you could then choose to create the connection in the system tab.
Excel_Query_to_XSTUDIO_V1.0.docx