怎么读取txt文件并转成dataset？----谢谢

Question

我从网上下载一个excel文件，可是他的真正格式是txt文件，只是用excel显示的，我现在想要读取他的内容，可是由于格式不是excel,所以报错。请教各位大虾，如何读取这个文件，最好有代码 c#，谢谢了。（下边是我的文件代码，你可以将他保存在txt文件中，然后把扩展名改称.xls就可以看到我的文件）
〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉
<style>
.txt {mso-number-format:"\@";border:none;}
</style>
<table class="dg" cellspacing="0" cellpadding="3" rules="all" border="1" id="amlEntryDataGrid" style="width:100%;border-collapse:collapse;">
<tr class="txt" style="background-color:#99CC99;font-weight:bold;">
<td><font class=dg_header>Sponsorship PartNumber</font></td><td><font class=dg_header>Manufacturer Name</font></td><td><font class=dg_header>Manufacturer PartNumber</font></td><td><font class=dg_header>Doc URL</font></td><td><font class=dg_header>Doc Type</font></td><td><font class=dg_header>Doc Status</font></td><td><font class=dg_header>Comments</font></td>
</tr><tr class="dg_item">
<td class="txt">
                    852-00608-00A
                        </td><td>
                    ACP ELECTRONICS CO.,LTD
                        </td><td>
                    fdsafdsa
                        </td><td>
                    http://localhost/partbuilder
                        </td><td>
                    type2
                        </td><td>
                    status2
                        </td><td>
                        this
                            </td>
</tr><tr class="dg_altitem">
<td class="txt">
                    852-00608-00A
                        </td><td>
                    ACP ELECTRONICS CO.,LTD
                        </td><td>
                    fdsafdsa
                        </td><td>
                    http://URL
                        </td><td>
                    type2
                        </td><td>
                    status2
                        </td><td>
                        this
                            </td>
</tr><tr class="dg_item">
<td class="txt">
                    852-00608-00A
                        </td><td>
                    ACP ELECTRONICS CO.,LTD
                        </td><td>
                    fdsafdsa
                        </td><td>
                    http://bpsiis01
                        </td><td>
                    type3
                        </td><td>
                    status2
                        </td><td>
                        this
                            </td>
</tr><tr class="dg_altitem">
<td class="txt">
                    852-00608-00A
                        </td><td>
                    ADVANCED CERAMIC X CORP
                        </td><td>
                    FDSA
                        </td><td>
                    http://url2
                        </td><td>
                    Type1
                        </td><td>
                    status2
                        </td><td>
                        this
                            </td>
</tr><tr class="dg_item">
<td class="txt">
                    852-00608-00A
                        </td><td>
                    ADVANCED CERAMIC X CORP
                        </td><td>
                    FDSA
                        </td><td>
                    http://url3
                        </td><td>
                    type2
                        </td><td>
                    status2
                        </td><td>
                        this
                            </td>
</tr><tr class="dg_altitem">
<td class="txt" style="background-color:Red;">
                    852-00608-00A
                        </td><td style="background-color:Red;">
                    ADVANCED CERAMIC X CORP
                        </td><td style="background-color:Red;">
                    FDSA-kevin
                        </td><td style="background-color:Red;">
                    http://url4
                        </td><td style="background-color:Red;">
                    type3
                        </td><td style="background-color:Red;">
                    status2
                        </td><td style="background-color:Red;">
                        this
                            </td>
</tr><tr class="dg_item">
<td class="txt">
                    852-00608-00A
                        </td><td>
                    ADVANTECH CO. LTD.
                        </td><td>
                    fdsafa
                        </td><td>
                    HTTP://URL
                        </td><td>
                    Type1
                        </td><td>
                    status2
                        </td><td>
                        this
                            </td>
</tr><tr class="dg_altitem">
<td class="txt">
                    852-00608-00A
                        </td><td>
                    ADVANTECH CO. LTD.
                        </td><td>
                    fdsafa
                        </td><td>
                    HTTP://BPSIIS01
                        </td><td>
                    type2
                        </td><td>
                    status2
                        </td><td>
                        this
                            </td>
</tr>
</table>
〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉〉

Answer 1

教你个方法,先打开excel,再打开文本文件,使用tab 或 空格 或这个文本文件的分格符.
再另存为excel文件.不要扩展名用双击打开.

Answer 2

 to lonelygames,
谢谢，我知道这样可以转化成excel格式。
可是我现在要做的是不改变任何格式，只是想把这个文件的数据取出来放进dataset中。然后再操作dataset。
谢谢你的关注，请继续关注，共同学习进步。