EXCEL转数据到SQL(已有表结构)
insert into Country123 ([Country_Id], [Region_ID], [Country_EN_Name], [Country], [Country_ALL_ID], [Country_Order_Id]) select [Country_Id], [Region_ID], [Country_EN_Name], [Country], [Country_ALL_ID], [Country_Order_Id] FROM openrowset( 'Microsoft.Jet.OLEDB.4.0', 'EXCEL 5.0;HDR=YES;IMEX=1; DATABASE=C:/Documents and Settings/Administrator.SM-8K7POQCBNFWO/My Documents/Google Talk Received Files/12-24.XLS',Country)