弱问:excel文件导入sql数据库的问题
现在的xls文件是直接从数据库导出的
现在想重新导入数据库
可是总是在对数据表进行填充时报错
“外部表不是预期的格式。”
代码如下
Dim mydatatable As DataTable = New DataTable
Dim myconnection As System.Data.OleDb.OleDbConnection
Dim mycommand As System.Data.OleDb.OleDbDataAdapter
myconnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(".") & "\" & FileName & ";Extended Properties=Excel 8.0")
' Select the data from Sheet1 of the workbook.
mycommand = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", myconnection)
mycommand.Fill(mydatatable)
~~~~~~~~~~~~~~~~~~~~~~~~~~~
就是对上面这句报错
请教高手们这是杂回事呢?