SQLSERVER与EXCEL文件互操作(读,写,插入)2007-12-2112:37:021:SELECT*INTOXLImportFROMOPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','DataSource=C:\testing.xls;ExtendedProperties=Excel8.0')...[Customers1$]SELECT*INTOXLImportFROMOPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel8.0;Database=C:\testing.xls',[Cu...