excel 导入sql 语句带变量,老写不对,请高手帮忙!
sqlcmd.CommandText = "SELECT * INTO fsdf1 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=c:\fsdf.xls', 'SELECT * FROM [fsdf$]')"
sqlcmd.ExecuteNonQuery()
这条语句运行是正常的,现在我想把c:fsdf.xls用 一个变量 fname 来代替
我写成了
sqlcmd.CommandText = "SELECT * INTO fsdf1 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database='& """ & fname & """, 'SELECT * FROM [fsdf$]')"
sqlcmd.ExecuteNonQuery()
系统报错,该了好多遍也不行,请高手帮忙该一下啊,引号和连接符号用乱了
[解决办法]
sqlcmd.CommandText = "SELECT * INTO fsdf1 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=c:\fsdf.xls', 'SELECT * FROM [fsdf$]')"
改写成如下:
sqlcmd.CommandText = "SELECT * INTO fsdf1 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=" & fname &
"','SELECT * FROM [fsdf$]')"
试一下.
If OpenFileDialog1.ShowDialog() <> Windows.Forms.DialogResult.Cancel Then
是不是改成:
If OpenFileDialog1.ShowDialog() = Windows.Forms.DialogResult.Ok Then
比较好一些?
