我环境是office2003 + sql2000
SELECT * INTO XLImport6 from
OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:/chaecode.xls";Extended properties=Excel 8.0')...[Sheet1$]
严重注意:excel的顶行要写成sql的字段名
我环境是office2003 + sql2000
SELECT * INTO XLImport6 from
OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:/chaecode.xls";Extended properties=Excel 8.0')...[Sheet1$]
严重注意:excel的顶行要写成sql的字段名