试下
sSql = "Insert Into [;DataBase=" & mydb_mdb & ";pwd=123456]." 稿升&友正 TableName & "好敬悔 Select * From [" & ActiveSheet.Name & "$]"
我也遇到这样的问题,请问您现在有解决吗?