# SQL 问题....帮帮忙

Posted by 初学者 on October 29, 1998 at 10:21:46:

将 EXCEL 档 用SQL语法将其内容加入MDB档(INSERT INTO.... SELECT ....)
combo1.text="sheet1$"
text5.text="c:\xls\aa1.xls
Data1.RecordSource = "insert into [入库单] ([入库单号],[入库日期]) select [入库单号],[入库日期] from ['" & combo1.text & "'] in '" & text5.text & "' 'EXCEL 5.0;' "
Data1.Refresh
会出现 from 叙述错误,
SQL 语法该是如何.....帮帮忙....谢谢

Follow Ups:

- Re: SQL 问题....帮帮忙 小蜜蜂 13:42:13 10/29/98 (0)