主题：请问当导入的excel表中的列名称含有特殊字符如何导入？

 帮助文档有一段导出的代码，你可以修改一下改成导入。

http://www.foxtable.com/help/topics/1148.htm

 导入excel的代码如下，放到命令窗口里执行，就行了。

Dim dlg As New OpenFileDialog
dlg.MultiSelect = True
If dlg.ShowDialog = DialogResult.OK Then
    Dim Book As New XLS.Book(dlg.FileName) '定义一个Excel工作簿
    Dim Sheet As XLS.Sheet = Book.Sheets(0)   '引用工作簿的第一个工作表
   
    Dim dtb As New DataTableBuilder("订单")
    For c As Integer = 0 To Sheet.Cols.Count -1   '添加列标题
        dtb.AddDef("zd" & c, Gettype(String), 32, "", Sheet(0, c).Value)
    Next
    dtb.Build()
    Dim t As Table = Tables("订单")
   
    For r As Integer = 0 To sheet.Rows.Count - 1 '填入数据
        Dim nr As Row = t.AddNew
        For c As Integer = 0 To t.Cols.Count -1
            nr(c) = Sheet(r +1, c).Value
        Next
    Next
    MainTable= Tables("订单")
End If