質問: "SELECT * INTO TESTCD FROM " & _ "OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', " & _ "'Data Source=C:\test\TEST.xls;" & _ "Extended Properties=Excel 8.0')...[TEST$]" ’**************このSQLの書き方がおかしいと思います。************* mCon.Execute(strSQL)
回答: スキーマが同じなら ``` INSERT INTO [SQLServerTable] SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\test\TEST.xls;Extended Properties=EXCEL 8.0')...[TEST$] ; ```