<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>Good Morning,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>Last week I asked if anyone knew how to connect Excel to the
Datamart. A fellow Datamart user sent in the instructions below. I hope you
find it useful.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>Steps in Excel:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>1. From the main menu, select Data -> Import
External Data -> Import Data<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>2. Click the 'New Source' button.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>3. Select Other/advanced from the list of options,
then click 'Next'<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>4. If attempting to connect to DB2, select the IBM OLE
DB Provider for DB2, then click then click 'Next'<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>5. Ensure the 'Existing data source'
radio button is selected, then choose your data source discussed
above from the drop-down list.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>5. Enter your User ID and Password provided to you by
the data source stewards, then click 'Test Connection'.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>6. Make sure the Allow saving password checkbox is not
selected. This is for security reasons and also to prevent the system
from trying to use your existing password to connect after you next change your
password.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>7. Click 'OK'<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>8. The Database alias should have your data source
pre-selected, but if not select it from the associated drop-down box.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>9. Enter your User ID and Password in the associated
fields and select the Shared radio button.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>10. Click 'OK'<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>11. Select the table/view you are interested in, then
click 'Next'.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>12. In the File Name text box, enter the name you want
for the odc. In the future, you will simply connect using the odc.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>13. Click 'Finish'.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>14. You will now be back at the Select Data Source
window with your new odc selected for you. Click 'Open'.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>15. You should see an Import Data window asking where
you want the data placed. Just go ahead and click 'OK'.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=4 face=Arial><span style='font-size:14.0pt;
font-family:Arial'>16. A connection window opens with your User ID
pre-selected. Enter your Password and click 'OK'.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=2 color=purple face="Times New Roman"><span
style='font-size:10.0pt;color:purple;font-weight:bold'>Linda Flicker</span></font><o:p></o:p></b></p>
<p class=MsoNormal><b><font size=2 color=purple face="Times New Roman"><span
style='font-size:10.0pt;color:purple;font-weight:bold'>Sr. Datamart Business
Analyst</span></font><o:p></o:p></b></p>
<p class=MsoNormal><b><font size=2 color=purple face="Times New Roman"><span
style='font-size:10.0pt;color:purple;font-weight:bold'>State Controller's
Division-SARS</span></font><o:p></o:p></b></p>
<p class=MsoNormal><b><font size=2 color=purple face="Times New Roman"><span
style='font-size:10.0pt;color:purple;font-weight:bold'>(503) 373-7277 Ext. 281</span></font><o:p></o:p></b></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>