Revision as of 21:38, 10 May 2012
Dflak (Talk | contribs)
← Previous diff |
Revision as of 21:44, 10 May 2012
Dflak (Talk | contribs)
Next diff → |
| Line 8: |
Line 8: |
| | This data is contained in several different formats. | | This data is contained in several different formats. |
| | <P> | | <P> |
| - | <table> | + | <table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0 |
| - | <tr> | + | style='border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; |
| - | <td>Employee File(CSV).csv<td> | + | mso-yfti-tbllook:1184;mso-padding-alt:0in 5.4pt 0in 5.4pt'> |
| - | <td>Comma Separated Variable Text File</td> | + | <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'> |
| - | </tr> | + | <td valign=top style='border:solid windowtext 1.0pt;mso-border-alt:solid windowtext .5pt; |
| - | <tr> | + | padding:0in 5.4pt 0in 5.4pt'> |
| - | <td>Employee File (Tab).txt</td> | + | <p class=MsoNormal>Employee File (CSV).csv</p> |
| - | <td>Tab Separated Variable Text File,<td> | + | </td> |
| - | </tr> | + | <td valign=top style='border:solid windowtext 1.0pt;border-left:none; |
| - | <tr> | + | mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; |
| - | <td>Employee File.xlsx</td> | + | padding:0in 5.4pt 0in 5.4pt'> |
| - | <td>Excell Spreadsheet</td> | + | <p class=MsoNormal>Comma Separated Variable Text File</p> |
| - | </tr> | + | </td> |
| - | <td>Employee.mdb</td> | + | </tr> |
| - | <td>MS-Access Database</td> | + | <tr style='mso-yfti-irow:1'> |
| - | </table> | + | <td valign=top style='border:solid windowtext 1.0pt;border-top:none; |
| - | <p> | + | mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; |
| | + | padding:0in 5.4pt 0in 5.4pt'> |
| | + | <p class=MsoNormal>Employee File (Tab).txt</p> |
| | + | </td> |
| | + | <td valign=top style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt; |
| | + | border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt; |
| | + | mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; |
| | + | padding:0in 5.4pt 0in 5.4pt'> |
| | + | <p class=MsoNormal>Tab Separated Variable Text File</p> |
| | + | </td> |
| | + | </tr> |
| | + | <tr style='mso-yfti-irow:2'> |
| | + | <td valign=top style='border:solid windowtext 1.0pt;border-top:none; |
| | + | mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; |
| | + | padding:0in 5.4pt 0in 5.4pt'> |
| | + | <p class=MsoNormal>Employee File.xls</p> |
| | + | </td> |
| | + | <td valign=top style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt; |
| | + | border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt; |
| | + | mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; |
| | + | padding:0in 5.4pt 0in 5.4pt'> |
| | + | <p class=MsoNormal>Excel Spreadsheet</p> |
| | + | </td> |
| | + | </tr> |
| | + | <tr style='mso-yfti-irow:3;mso-yfti-lastrow:yes'> |
| | + | <td valign=top style='border:solid windowtext 1.0pt;border-top:none; |
| | + | mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; |
| | + | padding:0in 5.4pt 0in 5.4pt'> |
| | + | <p class=MsoNormal>Employee.mdb</p> |
| | + | </td> |
| | + | <td valign=top style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt; |
| | + | border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt; |
| | + | mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; |
| | + | padding:0in 5.4pt 0in 5.4pt'> |
| | + | <p class=MsoNormal>MS-Access Database</p> |
| | + | </td> |
| | + | </tr> |
| | + | </table><p> |
| | Download these files here: [[xx]] to C:\Temp. Another directory can be used, but remember to translate C:\Temp to it. | | Download these files here: [[xx]] to C:\Temp. Another directory can be used, but remember to translate C:\Temp to it. |
| | <p> | | <p> |
| | ===Invoking MS-Query=== | | ===Invoking MS-Query=== |
| | + | <P> |
| | + | The method used to invoke MS-Query varies by the version of Excel used. This wiki displays the user interface associated with Excel 2007. However, once in MS-Query, the utility looks the same regardless of version. |
| | + | <P> |
| | + | MS-Query is launched from the Data Ribbon |
| | + | <P> |
MS-Query is a utility that imports databases, text files and other spreadsheets into Excel.
The method used to invoke MS-Query varies by the version of Excel used. This wiki displays the user interface associated with Excel 2007. However, once in MS-Query, the utility looks the same regardless of version.
Excel MS Query
