JJY

OPENROWSET

exec ('INSERT INTO OPENROWSET(''MICROSOFT.JET.OLEDB.4.0'',''Excel 8.0;HDR=YES;IMEX=2;DATABASE='+@path+''',
''SELECT * FROM [Sheet3$]'')(qHeaderId,structCode,queryName,queryDesc)
SELECT * FROM t_struct_query_header WHERE structCode = '''+@structCode+'''')

posted on 2009-03-14 23:29  MikeJia  阅读(138)  评论(0)    收藏  举报

导航